This discussion is archived
4 Replies Latest reply: Apr 1, 2011 1:26 PM by 777079 RSS

is the data for a loaded measure in a scenario stored in an Oracle table

599500 Newbie
Currently Being Moderated
Hi,

We have a few loaded measures which we update using our planning sheets. where does the updated data get stored in Oracle. We thought the rowsource is updated under the sandbox for the scenario in which the updates were done.

We are not able to find it in the rowsource though.

Regards,
Venkat
  • 1. Re: is the data for a loaded measure in a scenario stored in an Oracle table
    762759 Explorer
    Currently Being Moderated
    Those details are internal to our product and no decision or exploration should be based on where they are. We reserve the right to change it at any point. So, just use RSQL queries to access data or MDX query to access data that is loaded into cube,
  • 2. Re: is the data for a loaded measure in a scenario stored in an Oracle table
    599500 Newbie
    Currently Being Moderated
    Hi,

    But we are facing issues while loading incrementally the row sources.

    1. When new data is loaded into data source that the row source is built on, the new rows are not loaded into the rowsource
    irrespective of using replace/update with load command.

    2. Also if the row source measure has been updated in the planning sheet, but that measure details have changed in data source, it does not get over written in the scenario/row source.

    3. When rows are deleted from the data source, tehy are not deleted from the row source.

    4. Also we got a warnign while trying to load BOM Dimension which is a variable(row source) based dimension. Are we right in assuming, since it is based on the row source, we do not need to load dimension again?. Also members are not being deleted from the dimension.

    Regards,
    Venkat
  • 3. Re: is the data for a loaded measure in a scenario stored in an Oracle table
    809363 Newbie
    Currently Being Moderated
    Venkat,

    On 1, would need more info to debug.
    - What does the server log say when you load? -- You should see a messages about the number of accepted/rejected records.
    - Are there datasource and/or rowsource error logs?
    - Is your rowsource key defined properly? -- Could be that the records you are trying to add are not unique.

    On 2, scenario user updates are not written to rowsources.

    On 3, so you reloaded a datasource with fewer records and then ran a load replace? -- Again, I would run through the checks in 1 above. I'd also caution against table level debugging. They should be considered opaque and internal to iop.

    On 4, what's the warning? And are you sure you want to delete members? Generally with bom dims it's advisable to keep members around because otherwise you may be losing historic data.
  • 4. Re: is the data for a loaded measure in a scenario stored in an Oracle table
    777079 Newbie
    Currently Being Moderated
    Venkat,
    But we are facing issues while loading incrementally the row sources.
    1. When new data is loaded into data source that the row source is built on, the new rows are not loaded into the rowsource
    irrespective of using replace/update with load command.
    Data gets loaded into a datasource (LOAD). Data is moved from datasource to rowsource via a stagemap (STAGE).
    2. Also if the row source measure has been updated in the planning sheet, but that measure details have changed in data source, it does not get over written in >>the scenario/row source.
    User override takes precedence over loaded values. It does change the loaded value, but you can't see the change until you delete the override.
    If you want to remove the override, you need to do that via script as part of the load process.
    3. When rows are deleted from the data source, tehy are not deleted from the row source.
    Data is stored in the rowsource. You would need to remove it from the rowsource if you want the value to not be stored in the rowsource.
    4. Also we got a warnign while trying to load BOM Dimension which is a variable(row source) based dimension. Are we right in assuming, since it is based on the >>row source, we do not need to load dimension again?. Also members are not being deleted from the dimension.
    It is not normal to delete members from a dimension, as doing so deletes any data associated with any intersection of that dimension member.
    You may wish to make your BOM dimension time-varying, meaning the contents of the BOM changes over time, but storage of such a dimension is much more memory intensive, so be very careful in asking for this. It may be more effective maintain the BOM current+forward, and store calculated values for measures in the past.

    Thank you.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points