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

Errors ruuning Clear Package

Hi,

I am running the Clear package in OLS and I run into this error for certain months only

The member name is invalid::20070200 in TIME Dimension

Not sure what this error means.

Here is the complete log

TOTAL STEPS 3

1. Export_Zero: completed in 0 sec.

2. Load Cube: completed in 8 sec.

3. Clear Comments: completed in 1 sec.

4. Clear: completed in 1 sec.

Selection

-


ENABLETASK= Yes

CHECKLCK= Yes

(Member Selection)

Category: ACTUAL

Time: 2007.FEB

Entity:

Account:

BusType:

DataSrc:

Geography:

IntCo:

LOB:

PB_Function:

Product:

RptCurrency:

Messages

-


Load Cube

Warning

FPANDA

Warning

Submit Count : 1891 (Record count in source file : 1891)

Accept Count : 1889

Reject Count : 2

I know which 2 rows got rejected, but just don't know why.

Any help will be appreciated.

Thanks,

Rita

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 04, 2010 at 07:44 AM

    Probably the two records has at least a member for a dimension which is calculated.

    Clear is not deleting the records it is inserting records with oposite sign.

    Because of that you are receiving this error because you are trying to insert bad records.

    Actually if you will do Modify application or full optimize you will received an error.

    So I suggest to run the follow queries:

    select count(*) from tblfact"yourapp" where "dimension" not in (select [id] from mbr"dimension" where calc = 'N') for all dimensions of your appset except Time dimension.

    select count(*) from tblfac2"yourapp" where "dimension" not in (select [id] from mbr"dimension" where calc = 'N') for all dimensions of your appset except Time dimension.

    select count(*) from tblfactwb"yourapp" where "dimension" not in (select [id] from mbr"dimension" where calc = 'N') for all dimensions of your appset except Time dimension.

    If any of results is different by 0 then you have to replace

    select count(*) with delete and to run the query again.

    This will fis your appset and also the problem with clean.

    Kind Regards

    Sorin Radulescu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 04, 2010 at 08:24 AM

    Hi,

    You can have a look at following SAP note to solve your issue: 1447493

    Hope this will help.

    Kind Regards,

    Patrick

    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.