Multiprovider Design

[former_member523148]

Hi,

I have below 2 infocubes

1. ZGL01 which contains  characters --->  comp code, calquarter, GL Account

                                         Key figures  --->  Balance

2.ZGL02   which contains    characters-->comp code, Calquarter, Doc type, GL Account

                                         Key figures---> Debit, Credit

Now I created a multiprovider with those 2 infocubes like below.

                                      Dimensions              Comp code   ( Assigned this to both infocubes)

                                                                      cal quarter    (Assigned this to both infocubes)

                                        Key figures             Debit amt    ( Assigned to ZCGL02)

                                                                    Credit amt    ( Assigned to ZCGL02)

                                                                       Balance     Assigned to ZCGL01)

Now I have to created a Bex Query on that multiprovider like below.

                Compcode           Calquarter             Keyfigure1         Keyfigure2     Keyfigure3

                        Keyfigure1

                                      GL account( Equal to 111889)

                                       Doc Type(exclude SA)

                                       Debit amt

                        Key figure2   

                                      GL account ( Equal to 111889)

                                       Doc Type (Exclude SA)

                                       credit amt

                        Key Figure3

                                      GL Account( Equal to 116600)

                                       Balance

But when i run the query i am getting the same value for key figure1 and key figure2. I am not sure is there anything wrong with the query or multiprovider.

can anyone just tell me did i miss anything ?

[former_member523148]

just a small change to multiprovider

   Dimensions              Comp code   ( Assigned this to both infocubes)

                                         cal quarter    (Assigned this to both infocubes)

                                         GL account ( Assigned this to both infocubes)

                                        Doc type  ( Assigned to ZGL02)

        Key figures             Debit amt    ( Assigned to ZCGL02)

                                          Credit amt    ( Assigned to ZCGL02)

                                       Balance     (Assigned to ZCGL01)

[Former Member]

Hi,

Check the data at multiprovider level with the same selection criteria and see if debit and credit amount are same at that level.

Also,

The example of your report output is not understandable, it would be helpful if the look of the report is exact as you are getting. Try to include snapshot of report output if possible.

Thanks,

Mohammed.

[sbastien_francal2]

Hello,

The first thing to do is to double check your key figure assignment. It's easy to assign those 2 KFs (debit and credit) in the MultiProvider to the same KF from the underlying cube (ZCGL02 in your case).

If it's correctly mapped, do you get different amounts when querying cube ZCGL02?

If it does, trying running that MultiProvider query via RSRT with option "MultiProvider Explain".

Hope it helps,