Skip to content Skip to sidebar Skip to footer
Showing posts with the label Ssas

How To Disable The Double Click Option For Drillthrough Action In Ssas Cube

I have requirement to create the DrillThrough Action in SSAS Cube. Along with we will give DrillThr… Read more How To Disable The Double Click Option For Drillthrough Action In Ssas Cube

How To Query Date Field In Mdx With And Without Aggregate Group

I have a seemingly simple requirement to create a query of price data that will return four sets of… Read more How To Query Date Field In Mdx With And Without Aggregate Group

Ssas - Ole Db Error In Establishing A Connection

I have a problem when I try to process a SSAS project in Visual studio 2013 (sql server 2012) using… Read more Ssas - Ole Db Error In Establishing A Connection

Mdx Drillthrough Fails But Select Can Be Successfully Executed

I have the following MDX query which succesfully returns the measure when executed - SELECT {[Mea… Read more Mdx Drillthrough Fails But Select Can Be Successfully Executed

Calculating A % Rate Based On Two Date Dimension In One Cube

Set up - SSAS 2012 with OLAP cubes (built by supplier) and MS Report Builder v3. No access to BIDS.… Read more Calculating A % Rate Based On Two Date Dimension In One Cube

Ssas - How To Configure Format Number For Calculated Measures?

I created a calculated measure in order to allow user to display the operating margin about sales. … Read more Ssas - How To Configure Format Number For Calculated Measures?