Page 1 of 1

Multiprovider Query Design Fun!

PostPosted: Thu Jul 22, 2010 3:52 pm
by Yolanda
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

Re: Multiprovider Query Design Fun!

PostPosted: Fri Jul 23, 2010 9:07 am
by Yolanda
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!

Re: Multiprovider Query Design Fun!

PostPosted: Mon Jul 26, 2010 4:12 am
by El Belgio
tip: read docu on "constant selection" & "slow moving items"... it will "solve" your problem :wink:

Re: Multiprovider Query Design Fun!

PostPosted: Mon Jul 26, 2010 9:55 am
by Yolanda
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!

Re: Multiprovider Query Design Fun!

PostPosted: Tue Jul 27, 2010 10:18 pm
by El Belgio
you're very welcome :wink: