Use MDX cube and retrieve member properties

cristinapo — Fri, 06 Oct 2017 12:10:21 GMT

Hi everyone,

I tried to get some data from an MDX cube, which was fine, it worked. But the problem is how to also retrieve member properties as columns when running the code in Qlikview? or VBA, for that matter, since I'm also interested in that and in any other environment apart from SSMS.

I am able to do this in SQL Server Management Studio with the help of WITH MEMBER clause, but, when I copy this MDX query into Qlikview, it doesn't work because the WITH clause is not recognized in Qlikview. Below is a working example in SSMS that fails in Qlikview:

WITH

MEMBER [Measures].[Total Written If Not Signed Percentage] as [Policy - Section].[Section Reference].Properties( "Total Written If Not Signed Percentage" )

SELECT

{[Measures].[Written Or Estimated Premium],[Measures].[Total Written If Not Signed Percentage]}

ON 0,

{[Share Type].&[1],[Share Type].&[3]}

*{[Syndicate].[Syndicate Number].Children}

*{[TriFocus].[Department]. Children}

ON 1

FROM [Red] ;

Has anyone any tested solution or workaround?

Thanks a lot in advance!

Cristina

topic Use MDX cube and retrieve member properties in QlikView

Use MDX cube and retrieve member properties