Recent content by jcoira

Hi, I have seen several examples of creating parent-child datagrids. Orders and Order Details is a good one. It is very easy to navigate from order to order and display (or even modify) the details in the child grid. But, what if instead of loading all orders and details when the dialog loads...

Thank you guys. I will try PPJOSEPH suggestiongs right away. jc

Hi, I understand that if you create a .mde file you are not able to see (or at least modify) objects inside the .mde file. That is exactly what I want to achieve, but when I create a .mde file out of my MS Access 2002 .mdb file, I still have access to all objects in the .mde file. I can even...

I am working with visual basic express. I am having trouble with a code that works fine in VB6, but is giving me the error "Attempted to read or write protected memory. This is often an indication that other memory has been corrupted" in vb express. I need to use the following function from a...

Hi, I have designed a Data Mart to track potato contracting and receiving. It is running well except for one scenario. Here is a brief introduction to my data mart and the problem. For each load I receive: 1- I add a row to the fact table with all the corresponding dimension surrogate keys...

Hi AshishVinny, What is a multi star schema solution? Thanks, // jcoira

Thanks johnherman You have given me a good starting point to improve the design and the performance. I will try to include the load dimension in one fact table and see what happens. I will also take a look at Kimball's book, as you suggested. // jcoira

This is how the fact table and load dimension look like. Notice that I have the following dimensions in the design, and one surrogate key in the fact table for each one. Dimensions: Time_SK, Season_SK, Load_SK, Grower_SK, CropVar_SK, Supplier_SK, DestWarehouse_SK, Fieldsman_SK, Contract_SK...

My main concern is not which dimension to use, but what to do with this LOAD dimension. I just dont feel comfortable including 20 attributes that describe loads into the fact table. On the other hand the load dimension with several thousands of loads is killing the performance of MS Analysis...

I would say YES, it is like an event. Each time I receive a load with oranges I must record some quality measures(numeric additive facts) and attributes of the load like the carrier, the status and like 20 more. Is it ok to put those 20 attributes as non-additive measures in the fact table...

What is the advantage of making them dimensions? All I need is to get rid of the load dimension, which is growing at the same speed as the fact table. For each record in the fact table I insert one record in the load dimension. I think that is the cause of the bad performance, but I don't know...

Users want to see member properties of the load dimension. Sometimes they need to verify some of the member properties when making analysis. // jcoira

Thanks for the reply MDXer, What I actually need is to get rid of the load dimension or make the design to work well with it. I have around 20 attributes in the LOAD dimension, which is growing in parallel with the fact table. I think that is causing MS Analysis Services to give me slow...

Hi, I am designning a data mart and have a problem with one dimension table growing as fast as the fact table, that is slowing down the response times. I am using SQL 2000 and MS Analysis Services. We receive trucks loaded with oranges and they are graded to get some quality attributes. I...

Hi, I am designning a data mart and have a problem with one dimension table growing as fast as the fact table, that is slowing down the response times. I am using SQL 2000 and MS Analysis Services. We receive trucks loaded with oranges and they are graded to get some quality attributes. I...