This website is not affiliated with, sponsored by, or approved by SAP AG.

Multiprovider Query Design Fun!

Business Warehouse

Moderators: Snowy, thx4allthefish

Post Reply
Yolanda
Posts: 62
Joined: Mon Jul 21, 2003 4:35 pm
Contact:

Multiprovider Query Design Fun!

Post by Yolanda » Thu Jul 22, 2010 3:52 pm

Hi gurus !

I am implementing a Payroll Datamart.
I have Multiprovider that groups the “REAL” infoprovider and the “BENCHMARK” infoprovider.

The REAL one has the amount paid on employee level. Just like this:

Employee----Position----Amount
X-------------------A------------150
Y-------------------A------------120
Z-------------------B------------200


The BENCHMARK cube has the information of the amount each position should be paid in a perfect world

Position---Amount

A-------------150
B-------------220

What I need is a Query comparing what an employee was paid, with what he should be paid according to his position:

Employee-----Position-----Amount----BMAmount
X-------------------A------------150--------150
Y-------------------A------------120--------150
Z-------------------B------------200---------220

What I don’t want of course is the Query looking like this:

Employee-----Position-----Amount----BMAmount
X-------------------A------------150
Y-------------------A------------120
#-------------------A------------------------150
Z-------------------B------------200
#-------------------B------------------------220



¿What is the best way to model this Query?

Thanks in advance for your input.

Yolanda

Yolanda
Posts: 62
Joined: Mon Jul 21, 2003 4:35 pm
Contact:

Re: Multiprovider Query Design Fun!

Post by Yolanda » Fri Jul 23, 2010 9:07 am

Ok, ok, maybe is not drunkmakingout fun...

I just installed gui 7.10 It seems that there are now more options than a User Exit Variable

I´ll let you now guys!

El Belgio
Posts: 2576
Joined: Tue Oct 22, 2002 7:15 am
Location: back in rainland

Re: Multiprovider Query Design Fun!

Post by El Belgio » Mon Jul 26, 2010 4:12 am

tip: read docu on "constant selection" & "slow moving items"... it will "solve" your problem :wink:

Yolanda
Posts: 62
Joined: Mon Jul 21, 2003 4:35 pm
Contact:

Re: Multiprovider Query Design Fun!

Post by Yolanda » Mon Jul 26, 2010 9:55 am

El Belgio you sooo rule

I had tried to use the "Constant" functionality for the whole restricted value (in the enhanced tab), that of course did not work, the value was always the same.
What does work is checking "constant" only the infoprovder selection (in my example "BENCHMARK")

It's very usefull for all kind of Plan vs Real Multiproviders

Thanks a lot!

El Belgio
Posts: 2576
Joined: Tue Oct 22, 2002 7:15 am
Location: back in rainland

Re: Multiprovider Query Design Fun!

Post by El Belgio » Tue Jul 27, 2010 10:18 pm

you're very welcome :wink:

Post Reply