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
I have a Situation where I am looking for MDX Guidance. Environment: SQL Server 2008 R2,SSRS 2008 R2 Dimension:Columns
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.
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
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
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
I have this MDX expression in the Calculated member (sum([Time Code].[Time Code Group Code],[Measures].[Event Duration])-SUM([Time Code].
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.
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:
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.
加载中,请稍侯......