mdx
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 分类:问答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 分类:问答Updating cube (writeback) via MDX on SAP
does anybody know if SAP BW supports UPDATE CUBE statement in MDX query (connection to serve开发者_运维技巧r established via XMLA) ?? It returns some generic error and I cannot find any documentation.[详细]
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 分类:问答Olap/multi dimensional reporting, WPF client, agnostic data?
Can anyone give me general guidelines on how to approach multi dimensional reporting where I\'d like to support at the very least cube generated f开发者_如何学Gorom Oracle and SQL Server databases. I[详细]
2023-04-03 17:34 分类:问答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 分类:问答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 分类:问答Need MDX query for total count
Last time I had posted a question which was a bit confused. But today I got the same question from my manager to get the MDX query.[详细]
2023-04-02 17:13 分类:问答Display property of member in mdx query
I have a Mondrian/MDX query where I grab data within a date range, but I\'d like to return time as the value of its property in the result.My current query is like:[详细]
2023-04-01 17:27 分类:问答Multiplying Quantity * Price in Calculated Member
I know MDX is used for much more sophisticated math, so please forgive the simplistic scenario, but this is one of my first Calculated members.[详细]
2023-03-30 01:14 分类:问答