ssas

相关标签：javascript jquery android 多少钱 iPhone

Ordering By a Hierarchy Level?

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[详细]

2023-04-05 05:08 分类：问答
How to transparently show non-additive measures in Analysis Services as if they were additive

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[详细]

2023-04-04 22:55 分类：问答
SQL Server 2005 Analysis Service (SSAS) Partial Synchronization

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[详细]

2023-04-04 21:32 分类：问答
Second MDX Query has to return result for each row returned by 1st MDX Query

I have a Situation where I am looking for MDX Guidance. Environment: SQL Server 2008 R2,SSRS 2008 R2 Dimension:Columns[详细]

2023-04-04 13:36 分类：问答
Merge two MDX resultsets from the same measures group

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[详细]

2023-04-03 20:46 分类：问答
Business intelligence - Can't find the value I'm looking for

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.[详细]

2023-04-03 16:41 分类：问答
Slow Excel pivot table MDX?

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[详细]

2023-04-03 10:14 分类：问答
Why can't I create a simple SQL Agent Job or find correct syntax?

This works perfectly in a SSMS 2008 query window: use [HSS Maintenance] exec HSS_Guest.[olap storedprocedure][详细]

2023-04-03 07:44 分类：问答
For each implementation through SSAS 2005 MDX

I have this MDX expression in the Calculated member (sum([Time Code].[Time Code Group Code],[Measures].[Event Duration])-SUM([Time Code].[详细]

2023-04-03 02:45 分类：问答
Migrating SSAS Changes

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.[详细]

2023-04-01 02:11 分类：问答