http://en.wikipedia.o开发者_开发问答rg/wiki/Online_Analytical_Processing How is this two related? How to know that we are dealing with this type of programme?The two are often conflated but are not e
I need a mental process to design an OLAP database... E开发者_如何学Cssentially for standard relational it\'d be (loosely):
Are there any sites to learn OLAP and Dundas easily and quickly? A开发者_如何学Cnywhere can I also see the source code. Like how the controls are interacting with db and how the Dundas charting contr
I\'m developing a data warehouse and have come up against a problem I\'m not sure how to fix. The current schema is defined below:
I am trying wrap my head around how data is being served to Project Server. I am trying match up a value (actual cost) to project lines in an Executive View of Project Center which displays each proj
I\'m still learning the ropes of OLAP, cubes, and SSAS, but I\'m hitting a performance barrier and I\'m not sure I understand what is happening.
I am building a poor man\'s data warehouse using a RDBMS. I have identified the key \'attributes\' to be recorded as:
I\'m a complete newb to MDX / OLAP, \"data warehousing\" in general. I have the following MDX query and would like my results to display the month\'s number (1 = January, 12 = December). Luckily, the
We\'d like to create a simpler alternative to Excel\'s CUBEVALUE function for retrieving data from an OLAP server. The details aren\'t critical, but briefly, our function will \"know\" the source conn
I have been looking into PowerPivot and concluded that for \"self service BI\" and ahoc buidling of cubes it has its uses. In particular I like the enhanced UI that you get from using PowerPivot rathe