 Rank: Advanced Member
Groups: extranet\Forum
Joined: 2/20/2014(UTC)
Posts: 11
|
Hi all,
I've got two questions,
1)
I have got several saved collections (sammenlignigner) in my reports, is it possible to use collections in the criteria bar, so that I can filter by
the elements in that specific collection.
2) Is it possible to have a criteria that says OR instead of AND.
Because right know i can make two separate criterias eg. Month = January and Country = Denmark, but those two will do the intersect between those to sets. Instead i want the union.
Thanks in advance
Michael
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/1/2011(UTC)
Posts: 43
|
Hi Mikael
1) You cannot filter by "Comparisons" in the criteria bar (Sammenligninger)
2) Month = January and Country = Denmark will give you e.g. the revenue for the month January in Denmark.
if you used an OR expression then you would get the total revenue for ALL countries or if the country is Denmark (which doesn't make sense). I don't see the value in having an OR operator (except increase the complexity of the UI considerably). If it should be necessary I would suggest looking at creating a dimension capturing this business logic inside the data warehouse.
Peter
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 2/20/2014(UTC)
Posts: 11
|
Thanks for answer Peter,
Michael
|
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 4/6/2011(UTC)
Posts: 1
|
Not sure if this is what you are trying to accomplish? In the screenshot I am using stored criteria’s where the criteria’s has been made up by comparisons (sammenligninger :)). Just save each comparison (I did as Shared) then add ‘Stored Comparisons’ to the Criteria Bar and add those you would want to use as a filter. [img] http://tinypic.com/view....yo4&s=8#.UyRwo_ldWAU [/img] Screen ShotEdited by user Saturday, March 15, 2014 4:28:08 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
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.