Skip to Content

Processing the dimension_Yellow Status with out changes

Hi,

"Category" dimension's status changing to "Yellow" quiet often.When we process the dimension,it is being processed quickly.

In couple of days again changing to "yellow" status even though there are no modifications.So far we have not faced any issues with this status,but wanted know what is the reason for change of the status.

Thanks,

Manohar


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 06, 2015 at 02:45 AM

    Hi Manohar,

    please follow Gresh proposal to check for the changes.

    Please run the program UJA_REFRESH_DIM_CACHE program for the category dimension to make it Green.

    Thanks,

    Dinesh.V

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 05, 2015 at 07:30 PM

    Hi Manohar,

    You should be able to find out what changed in the Dimension from the cache table. If for example, technical name of InfoObject representing your Dimensions is /CPMB/ABCDEFG then look for table /1CPMB/*ABCDEFG where * can be B or empty. In that table you should be able to see field OBJVERS; check for records that have OBJVERS <> A.

    Those are changed members.

    Regards,

    Gersh

    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.