Skip to Content

Virtual InfoCube Modeling

Hi, I am going to use a Virtual InfoCube over a Custom Z Table. My Z Table has a Time Stamp field, but not the individual Time Characteristics like 0CALDAY, 0CALMON, that users will select on. Should I include these in the ZTABLE so they don't have to be resolved at runtime or should I just determine them from the timestamp at Runtime? What do you think is the best approach?

Thanks!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 23, 2006 at 01:57 PM

    If the logic is this, you can determine them from the timestamp at runtime without putting fisical fields on ztable.

    Hope it helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      If you have control over the ZTABLE then into the ZTABLE - anything to minimise the IO at run time is preferable

      Of course you can derived the cal day by doing a look up and IF statements - but it's all extra IO

      I do all derviation in Virtual cubes on the R3 function moudle or changing the source data (if I have control over it) - rather than any data in BW

      That includes denormalising the structures coming down - so design is column based rather than row based - thus the number of packets txf at run time is small

      I tend to do all calculations up front as well

      You are looping around the itab in the function module anyway before popluating the output table - do as much in there as possible - if you do it in BW you are only going to loop around again

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.