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

Multiprovider Query Design Fun!

Business Warehouse

Moderators: Snowy, thx4allthefish

Multiprovider Query Design Fun!

Postby 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

Re: Multiprovider Query Design Fun!

Postby 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!
Yolanda
 
Posts: 62
Joined: Mon Jul 21, 2003 4:35 pm

Re: Multiprovider Query Design Fun!

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

tip: read docu on "constant selection" & "slow moving items"... it will "solve" your problem :wink:
El Belgio
 
Posts: 2576
Joined: Tue Oct 22, 2002 7:15 am
Location: back in rainland

Re: Multiprovider Query Design Fun!

Postby 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!
Yolanda
 
Posts: 62
Joined: Mon Jul 21, 2003 4:35 pm

Re: Multiprovider Query Design Fun!

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

you're very welcome :wink:
El Belgio
 
Posts: 2576
Joined: Tue Oct 22, 2002 7:15 am
Location: back in rainland


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 3 guests





loading...


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