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

Not display records in a cube

Hi everybody,

I have a problem in moving data from an ODS to a CUBE. Here is an example of the problem:

ODS

Order: 1

Item: 100

Completion date: blank (the line is not completed yet)

I move the data into a cube (here 0calday is the allocation date and not the completion date which I defined as a characteristic)

CUBE:

Order: 1

Item: 100

Completion date: blank

when the order line is completed and the completion date in the ods is replaced by a date...copying the data into the cube means to have 2 records in the cube....

one (the one above) with all the key-figures put to 0.... the other one...is the correct one...with the correct completion date and the correct key-figures..

how to not display the wrong record?

I tried by putting in the cube the 0recordmode and linking it to the same field of the ods i got in the comm_structure (from the update rules)...But it doesn't work... because in the end I have 3 records:

1. X - order 1; item 100; completion date blank; kf not ok

2. # - order 1; item 100; completion date blank; kf not ok

3. # - order 1; item 100; completion date 10.10.2006; kf ok

and I cannot filter by X or #....

is there anybody who can help me?

many many thanks

Marco

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2006 at 05:47 PM

    Marco,

    have you kept that completion date as key figure? try keep that one as keyfigure and let me know. don't keep it as charecterstic.

    another option is if you don't want to see completion date space documents then you can filter in the IP. you won't those value to infocube.

    Regards,

    Nagesh Ganisetti.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2006 at 05:57 PM

    Hi Marco,

    You are loading data into CUBE at a granularity of item level and day level. What is the point of using CUBE. Why cant you generate same reports on ODS...??

    You have overwrite facility in ODS and you will get only one record for specific set of key fields.

    Hope it Helps

    Srini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2006 at 05:56 PM

    Ok Nagesh,

    I'll try...but then, will it be possible to make some analysis on that date?? I need to filter the data by the completion date and not by the 0calday(in which i stored the allocation date)....

    thanks

    Marco

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2006 at 06:08 PM

    Hi Srini....

    It was just to make an example.....but I have the line detail only in the ODS while in the cube I have details up to the order number...

    thanks

    bye

    Marco

    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.