March 8, 2006 at 3:18 pm
Hi !!
I'm constructing a DW, and i'm having a problem of functional definition of my datawarehouse. As you all know, you can easily extract multidimensional queries from a cube including agrupations of data. However, when it comes to inspecting my data at the most granular way (inspect a number of rows) i cannot see how to do it. I don't know if I have a misconception of what a datawarehouse is, but I imagine the following example:
A guy exploits an Excel Pivot Table service, browsing through sales statistics until he sees a number that caughts his attention. In that moment, he wants to browse an specific set of rows between two dates, because he wants to see an specific set of sales => so, we are talking about rows here. Are any of the Microsoft Tools prepared to do this ? Do I have to develop my own tool for this part of the process ?
Thanks
March 8, 2006 at 4:49 pm
The two common design model of a DW are the STAR and SNOW-FLAKE schemas. You will need to do a bit of research to find out the advantages/disadvantages of using each schema.
Once, you have a DW built, then you can use a product like Analysis Services (AS) to build your multi-dimensional database using the DW. AS will allow the user to drill-down the data for more detailed information. In addition, you also have Reporting Services, which you can use to generate the reports based on the user's query.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply