olap
Multidimensional databases and online analytical processing (OLAP) how it is related?
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[详细]
2023-01-12 21:09 分类:问答How do you design an OLAP Database?
I need a mental process to design an OLAP database... E开发者_如何学Cssentially for standard relational it\'d be (loosely):[详细]
2023-01-12 17:59 分类:问答OLAP, Dundas, C#.Net: Is there any sites to learn easily and quickly?
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[详细]
2023-01-12 13:01 分类:问答Data Warehousing Design Question
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:[详细]
2023-01-11 12:16 分类:问答How to add Enterprise custom field to display actual costs from a different DB in Project Server?
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[详细]
2023-01-10 06:26 分类:问答Why does my cube compute so slowly at the lowest drill down level?
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.[详细]
2023-01-05 21:42 分类:问答Database warehouse design: fact tables and dimension tables
I am building a poor man\'s data warehouse using a RDBMS. I have identified the key \'attributes\' to be recorded as:[详细]
2023-01-01 06:01 分类:问答MDX query- How do I use a member property?
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[详细]
2022-12-31 06:03 分类:问答Is it possible to create an efficient UDF alternative to Excel's CUBEVALUE function?
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[详细]
2022-12-30 12:13 分类:问答Analysis Services with excel as front end - is it possible to get the nicer UI that powerpivot provides
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[详细]
2022-12-30 07:27 分类:问答