Basically I want to know which one of is better for accessing cube using Analysis services. My requirement is to fetch the开发者_StackOverflow中文版 data and display as drop down for filtering the rep
Hi i\'m struggling with adding time dimension to OLAP cube. I can get everything in cube to work except date.
I\'m trying to figure out how I can create a calculated measure that produces a count of only unique facts in my fact table. My fact table basically stores events from a historical perspective. But I
Is there a way to trace the actual MDX generated by querying a Cube in Excel, and get the actual MDX used ?
The following is giving me the error in the title. Any help would be greatly appreciated. SELECT([Day].Children ) ON ROWS,
I\'m getting two right parentheses for negative nu开发者_高级运维mbers in my cube for all measures.Can\'t figure out how to fix it:
I am using AMO to programmatically generate an OLAP Cube. How can I add translations for the calculated members? (SQL Server 2008)
So we can take such image from wikipedia And try to map it for future cube or something like cube And than distort for top and bottom like
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
We have abo开发者_开发问答ut 10-15 dimension tables that reflect different levels of granularity and about 15-20 metrics we want to track. Does it make more sense to build one cube at the most granula