Skip to Content
author's profile photo Former Member
Former Member

Questions where i cant find answers in the forum.

Hello Masters,

1) I have 10 cubes I created multiprovider I want only 1 cube data what u do?

2) I have 3 cubes for that I created multiprovider and I created a report for that but I didnu2019t get data in that report what happen?

3) I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading

4) remodeling is applied only on info cube? why not dso/ods?

5)I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see?what is that tool pls?

can any one help with these questions??pls

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Sep 07, 2011 at 05:45 PM

    Hi,

    4) remodeling is applied only on info cube? why not dso/ods?

    Remodeling on DSO is a new feature available from BI 7.3 which enables to change the structure of a DSO already loaded.

    Check the link http://premkolipaka.blogspot.com/2011/08/remodeling-on-dso.html

    I think the reason why it was not possible to remodel a DSO can be its rigid design and the possible performance factors that may arise out of it. You may experenice performance problems on the table conversions especially where there is a large amount of data. Check the SAP note 1287382.

    3) I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading

    This is very difficult to explain unless you tell us what are you loading. What i suspect here is that you might have written some routine which loops/selects data from some other table or from the same DSO. Or may be you are loading a full infopackage and as the source system table size is increasing so is your runtime.

    For your queries 1 and 2 i would suggest that you read some more about the multiproviders. Check out the following links:

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b03b7f4c-c270-2910-a8b8-91e0f6d77096?quicklink=index&overridelayout=true

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2f5aa43f-0c01-0010-a990-9641d3d4eef7?quicklink=index&overridelayout=true

    These are some good articles by SAP itself.

    Hope my information helps you in your doubts.

    Regards,

    Kush Kashyap

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Durgesh,

      Have a small clarification. In BI 7.x we have the optiion of adding Chars/KFs by without deleting the data from Cubes. From Loading point of view, if you want hostorical data for the new added chars/KFs, we need to delete(selectively) the data from Cube and then do a reload.

      I think this is correct. Please advise if it is otherway around.

      Thanks,

      Raju

  • Posted on Sep 07, 2011 at 05:37 PM

    Hi,

    5. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see?what is that tool pls?

    You can use the the Program /SSA/BWT or transaction ST13

    The Program u201C/SSA/BWTu201D provides the following BW Tools:

    Process Chain Analysis

    Detailed Request Analysis

    Aggregate Toolset

    Infoprovider BPPO Analysis

    Goto SE38 and Type in u201C/SSA/BWTu201D as the Program name and click on execute.

    By default the option u2018Process Chain Analysisu2019 is selected. Click on the execute button. Then you are displayed with the options, select to perform analysis at Process Chain level.

    Regards,

    Kush Kashyap

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 07, 2011 at 07:43 PM

    1) I have 10 cubes I created multiprovider I want only 1 cube data what u do?

    Ans : In report , restrict infoprovider by the 1 which you want. this will give you data from 1 cube.

    2) I have 3 cubes for that I created multiprovider and I created a report for that but I didnu2019t get data in that report what happen?

    Ans : Try to find out the query filter in your report. is that filtering out data and showing blank records. Also check the infoproviders, do they really have data what u are looking for. Also check the varaibles, are they populated correctly.

    regards,

    Vinu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.