en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Michael Eget  
#1 Posted : Tuesday, March 4, 2014 2:58:35 PM(UTC)
Michael Eget
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
Peter  
#2 Posted : Tuesday, March 4, 2014 4:32:52 PM(UTC)
Peter
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/1/2011(UTC)
Posts: 39

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
Michael Eget  
#3 Posted : Friday, March 7, 2014 8:32:06 AM(UTC)
Michael Eget
Rank: Advanced Member

Groups: extranet\Forum
Joined: 2/20/2014(UTC)
Posts: 11

Thanks for answer Peter,


Michael
Ulrik Pedersen  
#4 Posted : Saturday, March 15, 2014 4:14:08 PM(UTC)
Ulrik Pedersen
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 Shot

Edited by user Saturday, March 15, 2014 4:28:08 PM(UTC)  | Reason: Not specified

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