en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Páll Bjarkason  
#1 Posted : Tuesday, February 28, 2012 3:06:29 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

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

I have a table with services to klients per month.
I want to get a subseet of the klients that get service 1 AND not sevice 2 each month!
I have tryed to use negation in comparisons, but I have had no luck so far.
Is there a sollution to this problem in TARGIT?
Best regards

Páll, CTS
David L. Bojsen  
#2 Posted : Tuesday, February 28, 2012 3:31:09 PM(UTC)
David L. Bojsen
Rank: Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 6

Depends very much of how your cube is made.

We had same issue, and had to change our cube design to make this possible in Targit.
Now we have different attributes for each service, where we before had a more generic service term,
and an on/off indicator.

I have not found any way to do this in Targit with the generic approach,
although it is possible in a MDX query.

/ David - TELMORE
Páll Bjarkason  
#3 Posted : Thursday, March 22, 2012 11:11:42 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

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

You are spot on. This problem is easily solved in the backend.
I tried to solve the problem with a generic approach in the TARGIT client front end environment - with no luck so far. I also assume that this approach's success depends on cube design. Tx.
Best regards

Páll, CTS
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