Subset = service 1 and not service 2

Options

Holbæk kommune - Páll Bjarkason

#1 Posted : Tuesday, February 28, 2012 2:06:29 PM

Rank: Advanced Member

Groups:

Joined: 1/13/2012
Posts: 35

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

Report Abusive | Report SPAM

User Profile
Hide User Posts

TELMORE - David L. Bojsen

#2 Posted : Tuesday, February 28, 2012 2:31:09 PM

Rank: Member

Groups:

Joined: 4/5/2011
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

Report Abusive | Report SPAM

User Profile
Hide User Posts

Holbæk kommune - Páll Bjarkason

#3 Posted : Thursday, March 22, 2012 10:11:42 AM

Rank: Advanced Member

Groups:

Joined: 1/13/2012
Posts: 35

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

Report Abusive | Report SPAM

User Profile
Hide User Posts

Users browsing this topic

- Anonymous