Forum Discussion

miloszmalecki's avatar
miloszmalecki
New Contributor
12 months ago

Dynamic Member List

Hi OS Community, I am just wondering if any of you had a chance to build dynamic member list or some similar functionality which allows you to have a specified member list which will be used in a p...
Cubeview
Finance
XFBR
miloszmalecki's avatar
miloszmalecki
New Contributor
11 months ago

JackLacava  Thanks for this solution. But still i have got the same problem :

I know how to use this functionality in Rows or Columns. I was using more primitive way: 

U1#CU003900.Base.Where(Name Contains XFBR(CKA_ParamHelper, returnLeft2, Ent=|!ParamFormPromptEntity!|))

CKA_ParamHelper: 
If args.FunctionName.XFEqualsIgnoreCase("returnLeft2") Then
Dim EntName As String = args.NameValuePairs.XFGetValue ("Ent")
Return EntName.Substring(0,2)
End If

 

But my problem is different. Both dimensions Entity and U1# i am using in Parameters. if i am using in U1# parameter of entity then i am getting this error as attached above. And this is my problem. If there is a way where i can use a parameter for U1# which will be looking at entity which were selected.