Skip to Content

Value 20140 of characteristic 0CALQUARTER is not plausible

Hi all,

I've created an info object which references 0CALQUARTER characteristic. In my cube, I have mapped a date field to this info object ( through direct assignment ) in order to get the quarter of that date but the error "Value 20140 of characteristic 0CALQUARTER is not plausible" is raised when loading data.

Any ideas how this can be solved? The info objects referencing 0CALYear and 0CALMonth are working properly but not the quarter.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on May 06, 2015 at 09:44 AM

    Hi,

    In mapping use rule type as formula, in that you have date functions, use function DATE_QUARTER(calculate Quarter from date).

    Hope it helps.

    Regards,

    Vengal.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Parvaneh Farzanegan

      Hi,

      You can check how the data is built in such way using RSA3 transaction in source system ( I assume you have calquarter in your datasource). Debug your dtaasource and you will find out why quarter is calculated wrong. Most probably it gets the first 5 characters of the calday field.

      Hope it gives an idea.

      regards

      Yasemin...

  • author's profile photo Former Member
    Former Member
    Posted on May 06, 2015 at 07:24 AM

    Hi

    The value 20140 for calquarter not valid therefore you get this error.

    In your source data check the date field and find out if there are invalid/incorrect entries .

    Is the source a PSA? Sometimes invalid date fields come in your PSA and cause such problem while loding to upstream target.

    You either need to correct such records in source or exclude them in loading.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 06, 2015 at 08:41 AM

    Hi,

    please cross check source and target fields length and types.

    need to be similar/same other wise you may get issue like above.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 06, 2015 at 12:36 PM

    Hi,

    You have mapped new infoobject (ZIOQUAR) having refernce characteristics as cal quarter with calday so new info object in target is not getting quarter value. Since the length of ZIOQUAR is same as 0calquarter so its appending 5 values. But If you use the formula at transformation level Date_Quarter(calday)then it will get execute.

    Thanks,

    Swapna Jain

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 06, 2015 at 12:48 PM

    Thanks every body.

    I have used Vengal's workaround(Formula in the transformation) and I can now extract the quarter of the date field and store it in the info object.

    It seems that the root cause of the problem is the missing conversion routine and you want me to choose a routine for my custom info object. Right?

    But the thing is that in the properties of that info object, as shown below, the system does not allow me to choose any routines from the list of values.


    Capture.PNG (25.9 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Loed,

      Thanks for reminding but I only got a workaround to the problem and I'm still waiting to find the root cause.

      As mentioned in my previous post, when creating an info object which references 0calquarter or even 0calmonth, the system doesn't let you change the conversion routine.

      So what shall I do?

      Thanks

  • Posted on May 12, 2015 at 04:02 AM

    Hi,

    I worked on it and i found that as I create new info object with reference characteristics 0calquarter, Its inheriting all the properties of 0calquarter. So there conversion routine PERI5 is available.

    I am not getting why are you changing.

    And one more thing since you are creating a info object with reference characteristics so you cant change anything like data type, tables everything. You can change description only. It's a property of reference characteristics info object.

    Regards

    Swapna Jain

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Swapna,

      Thanks for spending time on this.

      When I create an info object referencing 0CalMonth, the conversion routine is available in the properties of the object but not when referencing 0CalYear and 0CalQuarter ( And the 0CalYear IS working without any conversion routines, not sure if this is normal)

      Regards,

      Parvaneh

  • Posted on May 12, 2015 at 04:30 AM

    Hi,

    Conversion Routine is available when you are referencing new info object with reference characteristics info object 0cal quarter. Check the attached file.


    io.JPG (40.4 kB)
    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.