prompt many issue

[maxchuie]

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

[MFGF]

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.

[maxchuie]

hi MF,
yes the prompt query is using a caption
caption(model.dimension.Hierarchy.Level)

There are 4 members so far but could expand

[maxchuie]

Members (model.dimension.Hierarchy.level)

should i use rootmembers?

[MFGF]

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.