There is no filter function.
You say you are trying to create a query item with that expression. Can you go into a bit more detail about what you are trying to accomplish so that I can understand that and recommend an approach to the problem. It strikes me that a clearer understanding could enable you to be successful.I'm guessing that you are trying to filter a column called store_cd so that only those records which have the value AB are returned. What you are trying is not a supported method. There are methods to perform filtering. I've included a link to a blog topic I wrote which might help. Modules have a fairly extensive set of filtering methods and they provide flexibility to the modeller. You can create an embedded filter on a query item or using the expression editor. You can also create a stand alone filter, either in the query subject or in the module, which can be added to your report to apply the filter.
You are using square brackets in your expression. Are you using a FM package as your data source?
Here is a little bit about the various filter types available.
Hi Corrie,Sorry to hear about the difficulties that you're having.Have you tried an expression like: case when [country] = 'AB' then [quantity] endThe regular aggregate can be set to control the summary operation.You can also code the summary operation into the expression and set the regular aggregate to 'calculated'. Something like: total ( case when [country] = 'AB' then [quantity] end) With those kinds of expressions you can also define the scope of aggregation as in: total( case when [country] = 'AB' then [quantity] end for [product line] )The expression reference guide on operators, such as case expressions can be found at: Operators - IBM Documentation
I hope this helps.
------------------------------Kind regards,HENK CAZEMIER------------------------------
Instead of using filters, DM actually exposes the individual members as MUNs. You can't really see it from inside reporting, but you can from DM:In the properties you'll see: That identifier is basically the MUN, and you can use it as such.Americas looks like: [C].[C_Great_outdoors_sales_data_module].[page_9].[Region]->[Americas] Asia Pacific would be: [C].[C_Great_outdoors_sales_data_module].[page_9].[Region]->[Asia Pacific]Stick them into data items, and drag them in exactly the way you would with a dimensional source:The interesting thing is you can use dimensional functions, but getting the hierarchy is a bit difficult. This works: topCount(set([Americas],[Asia Pacific]),1,[Revenue])If you need to reference currentMember, use the hierarchy function: tuple(prevMember(currentMember(hierarchy([Americas]))),[Revenue])Extending it further we can call the hierarchy and see the all member, and even get the MUN of the all member with roleValue('_memberUniqueName',currentMember(hierarchy([Americas])))I've attached the report xml. It's based on the Great outdoors data module in the 11.2 samples.