Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jcoira

    Help, parent-child datagrids

    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...
  2. jcoira

    How to hide objects in mde format

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

    How to hide objects in mde format

    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...
  4. jcoira

    Help! - Error: Attempted to read or write protected memory

    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...
  5. jcoira

    Problem with a 470000-records dimension

    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...
  6. jcoira

    Dmension growing along with FACT

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

    "Monster" dimension causing problems

    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
  8. jcoira

    "Monster" dimension causing problems

    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...
  9. jcoira

    "Monster" dimension causing problems

    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...
  10. jcoira

    "Monster" dimension causing problems

    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...
  11. jcoira

    "Monster" dimension causing problems

    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...
  12. jcoira

    "Monster" dimension causing problems

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

    "Monster" dimension causing problems

    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...
  14. jcoira

    Dmension growing along with FACT

    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...
  15. jcoira

    "Monster" dimension causing problems

    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...
  16. jcoira

    Error in Transfer Objects Task

    Thanks !! DTS creates a log file to script the objects it has to move. The proxy account which executes the DTS did not have access to that "log" file. My problem is solved now.
  17. jcoira

    Error in Transfer Objects Task

    Hi, I have a DTS package with one Transfer Objects Task to extract data from a transactional system into a data warehouse. The transactional system is in a different server than the DW one. They are linked servers. When I run the package I get the following error Error string...
  18. jcoira

    Hierarchies across dimensions

    Hi, I have customers, stores and products and a neat dimensional design as we can find in any book. But I want to be able to drill down using a hierarchy across dimensions like, - Stores - Customers - Products I want to select a store and then see all customers that bought some...
  19. jcoira

    Staging tables structure?

    Well actually Im involved in the enterprise data warehouse. I would like to use surrogate keys, SCD and some other techniques. I don't know whether I should use an ODS layer or not. Also I need to know the structure of such an ODS layer in case I use it. Could you tell me a bit about that...
  20. jcoira

    Staging tables structure?

    Hi, But the drawback I see with the approach of having so many "set of tables" is that I have guarantee the quality of data in all those tables and therefore the audit process could be more difficult to implement. What do you think? // jcoira

Part and Inventory Search

Back
Top