mdx
MDX Calculated member Sum of selected members rollup
I\'m trying to write a calculated member that will roll up along a dimension based on the selected values provided on the axes.[详细]
2023-02-20 17:38 分类:问答Get names all currently available members
I haveAction URL which will open web site from excel.I need to pass names of all employee which are currently listed in excel to that web site. This list is coming from cube and could be filter by use[详细]
2023-02-20 04:07 分类:问答Displaying multiple hierarchy levels in an MDX query
I\'m trying to get the following data from a TFS OLAP cube in a single query [Work Item].[System_ID] | [Work Item].[System_Title] | [Measures].[BaselineWork][详细]
2023-02-20 01:53 分类:问答Defining a SUM calculated member on a dimension property in a cube
I am an OLAP/MDX newbie so pardon me if this is too obvious of a question. I am trying to define a MDX calculated member which will SUM the values from a dimension property but unable to do so. I am[详细]
2023-02-17 18:57 分类:问答MDX Calculating 12 month average unit price and applying to forecast quantity
I have a requirement to show a report which calculates the average selling unit price of each product and then multiplies this average by the number of units forecasted to sell in the next year (for e[详细]
2023-02-16 15:38 分类:问答SS 2008 R2 Analysis Services - Class not registered
I have a fresh 64 bit SS 2008 R2 install on a new server running 64 bit Windows 7. (No previous versions of SS). BIDS is running on the same box as SS 2008 R2.[详细]
2023-02-14 05:16 分类:问答Differing NON EMPTY behaviour in Analysis Server 2000 and 2008
We currently run a front-end Manager Information tool that connects to a SQL analysis server to provide flexible reporting. Essentially the front-end builds up some MDX which it then executes on Analy[详细]
2023-02-13 10:17 分类:问答MDX Query use most recent value
Hi I am no MDX Expert, so I need help, say I have a cube with the following data (simplified) Month EE CoCode Value[详细]
2023-02-13 10:14 分类:问答How to acess tuple/cell properties of MDX output through C#?
I have an MDX query I am pulling through using Adomd.net where cmd contains the command text. This, when run directly against a cube returns the following output, just a caption and the count integar[详细]
2023-02-12 12:21 分类:问答Tracing MDX generated by Analysis Services in Excel
Is there a way to trace the actual MDX generated by querying a Cube in Excel, and get the actual MDX used ?[详细]
2023-02-11 07:32 分类:问答