If you are on version 184.108.40.206.102 or higher, the pov members are stored on row 1 which may or may not be hidden. You could reference them directly with a formula to build your header
If you are not on the version you might look at the VBA function HypGetActiveMember (vtDimName, vtMember) you will have to di this in a macro then plug in the value where you want it
Thanks for your response.
I am not really good at VBA scripting. I am trying this function. Some how i am not able to make it work.
This is the Syntax I have found, And I am declaring the below function in the VBA, The statement is not running.(It;s in red color)
Public Declare Function HypGetActiveMember Lib "HsAddin" (ByVal vtDimName As Variant, ByRef vtMember As Variant) As Long
sts = HypGetActiveMember("Market", vtMem)
I may need your help How to use this VBA function in Smart view where I need to use ? Could you Please help me ?
If you give me a small Example, That would be great help fro me..
You can do that using VBA, how about using an EXCEL formula instead.
="This report for <"&Sheet2!A1&"> <"&Sheet2!B1&"> for the month <"&Sheet2!C1&","&Sheet2!D1&">"
This assumes that Sheet2 has POV members.
If you want to do it the VB way then
sts = HypGetActiveMember("Market", vtMarket)
'Add rest of the members here
Sheet1.Range("A1").Value = "This report for <" & vtMarket & "> " & " <" & vtAccount & "> for the month <" & vtMonth & "," & vtYear & ">"