I\'m trying to write a calculated member that will roll up along a dimension based on the selected values provided on the axes.
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
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]
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
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
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.
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
Hi I am no MDX Expert, so I need help, say I have a cube with the following data (simplified) Month EE CoCode Value
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
Is there a way to trace the actual MDX generated by querying a Cube in Excel, and get the actual MDX used ?