Do I have this right...It is not displaying correctly
#promptmany ('paramname','memberuniquename','[members]','set(','[Model].[Dimension].[Hierarchy].[level]',')')#
the only thing the data shows in the prompt
test1
test2
test1
test2
I need to display just test1
test2
Previous filter was Caption ([Model].[Dimension].[Hierarchy].[level)
TIA
Quote from: maxchuie on 30 Oct 2015 09:54:46 AM
Do I have this right...It is not displaying correctly
#promptmany ('paramname','memberuniquename','[members]','set(','[Model].[Dimension].[Hierarchy].[level]',')')#
the only thing the data shows in the prompt
test1
test2
test1
test2
I need to display just test1
test2
Previous filter was Caption ([Model].[Dimension].[Hierarchy].[level)
TIA
Hi,
Your prompt values should be populated by a query (assuming it's a value prompt)? What members is the prompt's query retrieving?
MF.
hi MF,
yes the prompt query is using a caption
caption(model.dimension.Hierarchy.Level)
There are 4 members so far but could expand
Members (model.dimension.Hierarchy.level)
should i use rootmembers?
Quote from: maxchuie on 30 Oct 2015 10:24:08 AM
hi MF,
yes the prompt query is using a caption
caption(model.dimension.Hierarchy.Level)
There are 4 members so far but could expand
That explains what you are seeing in the prompt, then. If you want to see fewer than those four members, you simply need to modify that query to return the members you desire. You can either specifically identify them within a set(), or exclude the ones you don't need with an except(), perhaps?
MF.