SSAS : MDX to get total SUM from the start to till date or mdx Cummulative sum

if you want calculate cummulative sum from the starting till date .

Then you need to use

SUM({NULL:[Date].[Hierarchy].currentmember},[Measures].[SIMID])

The above query gives from  from starting SIMID availble to till the end of the date dimension but  to restrict the cummulative value to only from start to latest date then use below query .


iif([Measures].[SIMID]>0,SUM({NULL:[Date].[Hierarchy].currentmember},[Measures].[SIMID]),null)



Comments

Post a Comment

Popular posts from this blog

SSIS :Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done

when we try to use table name as parameter is Execute sql task in SSIS Then we got this error [Execute SQL Task] Error: Executing the query "delete ? where [group] ='HTTP' " failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. After many trails we came to know that it i snot possible to pass table name as input parameter for the Execute Sql Task . Work Around to solve this issue : Create a Variable to build dynamic query . In the Expression of the Neqvarible pass the Tablename variable . "Delete "+ @[User::DestRateTableName]+ "  where [Group] ='HTTP'" In Execute Sql task select the SQLSourceType as Variable and  select the new variable in Sourcevariable co...
Read more

SSIS Error : Object is not an ADODB.RecordSet or an ADODB.Record + Solution

Problem : I have two script tasks in my SSIS package. The first one saves a string array as a package variable: // In 1st script task: String[] astrCustNames = new String[cust_count]; /* ... * Some code to add strings to array ... */ // Add array to a package variable Dts.Variables["CustomerNames"].Value = astrCustNames; The second task should then extract the strings from the variable. In the past, I've done this with a table variable. The same approach won't work for the string array: // In 2nd script task: OleDbDataAdapter ole_da = new OleDbDataAdapter(); // Fill the customer names data table DataTable dtCustNames = new DataTable(); ole_da.Fill(dtCustNames, Dts.Variables["User::CustomerNames"].Value); The call that fills the data adapter will result in the error "Object is not an ADODB.RecordSet or an ADODB.Record." The .dtsx package lists the data type as DTS:DataType="13" The data type of the variable as it is defined in...
Read more

SSRS : [Teradata Database] 3939 There is a mismatch between the number of parameters specified and the number of parameters required.

Error : [Teradata Database] 3939   There is a mismatch between the number of parameters specified and the number of parameters required. When we get this Error : when we are creating SSRS reports on Teradata database and in which when we are using parameters in the dataset in wrong style\format. Just for Info :  to connect Terdata we need to have  .Net Data provider for Terdata  when we installed this on our machine  Then we are able to see Teradata data source type in SSRS. How to Solve this issue :  This error will come if we are not using correct syntax to create parameterized data set .  The correct way is we need to ?  for parameter The report parameters can be named or unnamed. Teradata only supports unnamed parameters. An unnamed parameter is denoted by a ‘?’, and is merely a placeholder for data that is going to be entered at report processing time. For example, the following is a dataset with a single-value ...
Read more