Problem in Multiprovider

10-11  Source: Network gathering  Views:0 

Advertisement
Dear All,
I am creating a report on Multiprovider to analyze Plan vs Actual amount.
Plan data is sitting in one cube and actual data is sitting in another cube.
Now both individual cubes data are correct.
I have combined both cubes by MP. Now there are some issue with it.
When i see the report at GL(General ledger ex :- 446100, 45100) level char then plan data and actual data are getting picked up correctly, but the moment i include some other char like profit center or cost center then the actual amount does not come properly. It shows all zero.
Note only for few records data are getting picked up correctly.
Information:-
Structure of Actual cube:- Source is r/3.
1) ZCOSTCENTER -- Direct map to the source.
2)Profit center-- Direct map to the source.
3)GL CODE-- Direct map to the source.
4) Function code-- Given by the user as a flat file and is an attribue of the Cost center. In update rules i have applied read from master rule.
5) Business Area -- Direct input from the source.
6)Amout
7)Year
8)Posting Period
Structure of Plan cube:- Note source of the plan data is flat file.
1) GL code-- Direct map to the source.
2) Function code-- Direct input from the source.
3)Profit center-- Direct input from the source.
4) Business Area -- Direct input from the source.
5)Amout
6)Year
7)Posting Period
Need some pointers regarding the same.
I have selected the common objects present in both the cube during identificaton but still its not working. Only at GL level data are matching perfectly fine.
Thanks & Rgds,
Anup.
Hi Prakash,
Thanks for you reply.
1) Check Profit centres are mapped properly or not in MP.
Ans:- Since PC is coming from the both the source i have checked both the cubes in the MP.
2)And also check the available PC in both the cubes, how many are there.
Ans:- In plan cube we have just taken some test data and only 2 (unique)profit center are there but it is occuring at 15 cells whereas there are more numbers of unique profit centers in the actual cube.
Check the data with individual chars keeping total.
ANS: at GL level total data are matching and even without any char selected the total amount of actual and plan are matching. but the problem is when we insert some more characteristics.
Thanks & Rgds,
Anup
Related articles
  • Problem in Multiprovider 10-11

    Dear All, I am creating a report on Multiprovider to analyze Plan vs Actual amount. Plan data is sitting in one cube and actual data is sitting in another cube. Now both individual cubes data are correct. I have combined both cubes by MP. Now there a

  • Problem in Multiprovider Query 10-11

    Hi Experts,             I had developed an query on Multiprovider, which is on MM & PP Cube. In the Query Designer,i had created some new selection with  two characteristics restriction ( MOvement Type & Trans/Ev Type) and with a key figure.In the

  • Compounding consistency problem not ensured problem in multiprovider 11-30

    I have a multiprovider MP1 which has  CUBE1 & CUBE2 as its particiapting cubes.  Both of these cubes has infoobject 0FUND which is compounded with 0FM_AREA and I have included both( 0FUND & 0FM_AREA) of these infoobjects in MP1 and mapped it. Info

  • Basic problem in Multiprovider 11-30

    Hi, I have created multiprovider on 2 ODS Objects. Example: The structure and data in <b>My 1st ODS</b>: DOCNO    CUSTID    INV_AMOUNT    AMOUNT_PAID 1001         C01         500                    200 The structure and data in <b>My 2nd

  • #CONTEXT Problem in Multiprovider report 10-11

    Hi Experts, I Have 2 Data providers Query1: Material key, Material type, MRP Controller. QTY, Month/Year Query2: Material Key, Stock, Month/Year. I have created on variable based on Material type and MRP Controller. This is working fine for QTY But I

  • Multiprovider - BI planning - to which cube will be data save 10-11

    Hello, I solve the problem with multiprovider in BI planning. We have about 10 infocube connect in one Multiprovider. How can I ensure that the right data will be save to the right Infocube? I try it with Characteristic relationship but I have proble

  • Error in multiprovider 11-30

    Pls help me out in the problem My multiprovider is created using 2 cubes say cube1 and cube 2. I created a query on this multiprovider , but the results was strange as shown in the attched excel sheet. In Identification tab I have checked Sales Doc n

  • Error while executing query 10-11

    Hi all, I am not able to execute a report in BEx Analyzer. It keeps asking for userid and password and after that it gives message saying Query not yet calculated. When tried to execute again using the refresh button it disconnects from BW server. (I

  • How to revert back the changes that have made to Infoset 11-30

    Dear Experts, Can any one help me with solution for the below issue? I have activated(checked) some navigational attributes to the infocube "XYZ".This "XYZ" infocube is used in Infoset and as well as in multiprovider.Instead of activat

  • Multiprovider Query Problem 10-11

    Hi Gurus, The scenario is that there are 2 inficubes, one with order data and other with delivery data. The cube with order data has the requested delivery date and the delivery cube has the actual delivery date. The problem is that I have a query on

  • Multiprovider data problem 10-11

    Hi All, I have a multiprovider which is based on two cubes.There are some characterstics which are simliar in cubes like sales doc,item,ship_to,sold_to.The scenario is as follows:- The key figure on which I am reporting is from Cube2 and there is mix

  • Multiprovider transport problem 10-11

    Hello Friends , While transporting the  multiprovider from BW Development to BW Testing system I am getting following error in the Log display of BW Testing System, R3TRMPRO***(Multiprovider name) was repaired in this system. The log display for the

  • Problem with Report on Multiprovider 10-11

    Hi All, I am getting key fig value more than the expected value in the report output, Report is on Multiprovider, I have checked in to cubes, values in the cubes and reports are same, I have checked in TR and UR there is no routines, But Data source

  • Bw multiprovider problem 11-30

    hi all, i have a problem with a multiprovider. I activated 0FIAR_C03 cube in order to execute balance aging for customers. I want to calculate top N costemers' balance aging so I created a sales cube based on an S9* info structure. both cubes have ri

  • KYF problem in a multiprovider 11-30

    Hi sdn, I merely replaced one infocube with another but identical one in the Multiprovider definition. But now the data from that infocube is not coming in when I look through Listcube. Selection tab shows that the key figures is properly linked. Wha

  • Problem with Dimension created in Multiprovider 11-30

    Hi, I have a multiprovider which has 5 Infocubes in it.  There are seperate reports on both Infocube & Multiprovider.  I added 2 new fields in a Infocube under a new dimension.  I need this 2 fileds to be added to the Reports too.  When i open the Qu

  • Multiprovider report problem 10-11

    Let me explain you the Multiprovider report with example . Multiprovider is created based on Basic cube and DSO . Basic cube has Billing doc number in line item dimension . DSO has Billing document number , Item number and Partner function as primary

  • Multiprovider design -problem 10-11

    I am just creating the multiprovider on Custom Billing cube and Custom DSO . In my billing cube , I have Billing document assigned to line item dimension and Line item is also in another in another line item diemsion . My DSO have Billing document nu

  • Problem while running a query on multiprovider 10-11

    Dear all, I have created a query to generate the balance sheet in FIGL using standard virtual cube 0FILGL_V01 and a custom transactional cube which gets plan data through BPS. The custom plan cube is an exact copy of the 0FIGL_V01 (plan value is popu

  • Problem while running a query on a multiprovider 10-11

    Dear all, I have created a query to generate the balance sheet in FIGL using standard virtual cube 0FILGL_V01 and a custom transactional cube which gets plan data through BPS. The custom plan cube is an exact copy of the 0FIGL_V01 (plan value is popu