|
- How to get a latest date in cube DB using MDX
How to get a latest date in cube DB using MDX I need MDX query So, could you help any body of you know the answer Its very urgent Thursday, November 18, 2010 10:55 AM
- Sum of Rows and Columns in MDX - social. msdn. microsoft. com
I am looking for a MDX-Statement that retruns a table, in witch a sum for each row and Column is shown My result should look like that: Year AccountGroupA AccountGroup B RowSum 2004 15 23 38 2005 10 10 20 2006 8 15 23 2007 16 14 30 ColumnSum 49 62 111 Now I have following MDX Statement, that returns me a table, without the sums: Code Snippet SELECT
- INSTR Function in MDX - social. msdn. microsoft. com
I am not able to get the result dataset using the following query for a report However, when I removed the following query from main query then it is showing all the results I have to get it done by today itself Any help would be really appreciated
- Querying Analysis Services 2005 Cube with SSIS
I've been trying to use Analysis Services 2005 Cube as a data source, query it via MDX and then use the data returned elsewhere in SSIS
- MDX NewBe: MAX of SUM GROUP BY - social. msdn. microsoft. com
Executed by the mdx query in the SQL Server Management Studio the result of the following query looks pretty: Code Snippet WITH SET setCars AS ORDER
- MDX: Obtain the number of Month - social. msdn. microsoft. com
Here Index is not the month no It is no of positions to go back or front So if 3 is the Index and March is the month, it would return a set of Mar,Feb and Jan You can also use YTD (Date Calendar Month [] []) also or use Date Calendar currentmember Lag (3)
- MDX - Cube Calculated member - Year Over Year Growth Percentage by . . .
The query above works fine in my machine on Adventure Works What did you do? What's the error? Can you post your MDX? Karthik Tuesday, September 4, 2012 8:22 PM
- SSAS MDX to find Average - social. msdn. microsoft. com
0 Sign in to vote Hi Thanx u solved My Problem,I need to ask 1 more MDX syntex I am working on same cube I have defalut SR_Count Measure I have one Dimension name DIM_status with attribute name "Status" and values in it are "completed" and "incomplete" I want to create calculated Measure to find the percentage (SR_Count when status =complete SR
|
|
|