en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Jesper Kildevæld  
#1 Posted : Wednesday, June 12, 2013 2:03:26 PM(UTC)
Jesper Kildevæld
Rank: Newbie

Groups: extranet\Forum
Joined: 11/9/2012(UTC)
Posts: 2

I'm having a problem with an analasis which list sales to customers. It is used to calculate the bonus the customers should receive on their purchases in a give period, but there is some purchases that should not be part of the bonus calculations and therfore need to be deselected.

Ex. Invoice 10001
with the 2 articles xx1 and zz1

The article zz1 is a special discount which leads to that there should not be give bonus on invoice 10001 for none of the articles.

How can I make this kind of selections?

any help will be appreciated.
David L. Bojsen  
#2 Posted : Thursday, June 13, 2013 11:10:09 PM(UTC)
David L. Bojsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 3/21/2013(UTC)
Posts: 19

jeki@gram-commercial.com wrote:
How can I make this kind of selections?


Hi Jesper

I don't think this is something that can be accomplished solely in the TARGIT client.
(removing some fact records based on values on other fact records)

You can however make the selection (or deselection if you like) in the cube - if you are using a cube as your datasource.
This involves either putting some logic in the ETL jobs marking the orders not valid for bonus, or by working with calculated members,
and perhaps sets/dynamic sets in MDX.
Both solutions require you to have some BI developer skills, i'm afraid.
Venlig hilsen / Best regards

David L. Bojsen
Kapacity A/S

UserPostedImage

Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of my employer Kapacity A/S.
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