Hi,
I'm using CR Dev. 10 with MS SQL Server 2000 & Analysis Server to generate an OLAP Sales Report. I have 3 levels of Stores (Level 0 is All, Level 1 is Chains, Level 3 is Individual Stores). I have 5 levels for Time (Year,Q,Month,Week,Day). In it's current state everything functions as...
Hi,
I'm using CR Dev. 10 with MS SQL Server 2000 & Analysis Server to generate an OLAP Sales Report. I have 3 levels of Stores (Level 0 is All, Level 1 is Chains, Level 3 is Individual Stores). I have 5 levels for Time (Year,Q,Month,Week,Day). In it's current state, the cube is working, the...
Hi,
Thanks for the candid feedback. Okay, here is some more detail.
Currently, I have about 120,000 transactions growing at approximately 150 to 250 per day. The relevant tables are a sales table, and 3 other tables which form a 3 tier parent/child heirarchy. I have reports that simply...
Hi,
I'm working with CR v10 and am relatively new to reporting software and databases. I am trying to build a report that will allow me to compare sales from different periods. For example, I would like to know my stores did from week to week or month to month, etc. My database is SQL 2000...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.