I have used the ADventureWorksDW 2008 R2 SSAS db to recreate my problem.I have two queries, but one doesn\'t work and I\'d like to understand why.The first is not using a user hierarchy, and the secon
In my cube there are certain measures which are non-additive, however I can compute a value for every drill down level. Unfortunately the computation is too complex for it to be done in in Analysis Se
I\'m new to SSAS (this is my first project that involves ssas). I have a regular a SQL Server 2005 server (say Blah) that run database instance and sql server analysis service. I want to synchronize
I have a Situation where I am looking for MDX Guidance. Environment: SQL Server 2008 R2,SSRS 2008 R2 Dimension:Columns
I am trying to merge the result of two separate MDX queries, where the measures are from the same measure group. The cube design is based on a lifecycle transaction model, where the date are all role
I\'m setting up a SSAS project for our websites but I can\'t managed to find the good value whereas it\'s quite simple in plain SQL query.
I am having an extremely hard time with Excel being very slow whenever interacting with a pivot table.Adding/removing a field, changing a filter or slicer, all take several minutes of Excel being froz
This works perfectly in a SSMS 2008 query window: use [HSS Maintenance] exec HSS_Guest.[olap storedprocedure]
I have this MDX expression in the Calculated member (sum([Time Code].[Time Code Group Code],[Measures].[Event Duration])-SUM([Time Code].
Assume you have 2 SSAS databases, DB1 and DB2, that are identical. Now they开发者_运维技巧 branch off. Changes A and B are made to DB1 and changes C and D are made to DB2.
加载中,请稍侯......