en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
SO  
#1 Posted : Tuesday, April 7, 2015 6:36:06 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 88

If I have a crosstab showing all products, is it possible to add a filter to show only products with a certain phrase in the product name?

For example if I only want to show products with the phrase *car* in the product name?
And more advanced, combining two phrases, for example "*car* or *bicycle*"?

I'm trying to copy a Navision filter which is used to get some data for a report, in Navision the field filter is for example *car*|*bicycle*
Páll Bjarkason  
#2 Posted : Tuesday, April 7, 2015 8:41:07 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

Hi
In the criteria bar it is possible to search and select dimension members.
If you first search car and then search bicycle then you can filter all current dimension members.
The drawback is that the search is not dynamic. The search is only run once. Hence, when the decried members are chosen you have a static filter. If a new type of car is added to the dataset (which was not chosen earlier), then the filter will not pic it up.

NB You can also search dimension members when you build a comparison.

UserPostedImage
Best regards

Páll, CTS
SO  
#3 Posted : Tuesday, April 7, 2015 9:52:43 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 88

Thanks for the help. Then it looks like it have to be done manually with search as you describe, or try to figure out another way of retrieving the same data.

I was hoping it was possible with visibility agents or something similar so I could create a dynamic and auto scheduled report.
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error