Value 20140 of characteristic 0CALQUARTER is not plausible

[former_member220628]

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

[former_member186053 · Accepted solution]

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.

[former_member220628 · Accepted solution]

Thanks Vengal. The work around seems working but as I said, I would like to know the root cause of the problem.

[former_member186053 · Accepted solution]

Hi,

I think it is because of conversion routine is missing. You are trying get the quarter from date(ex:2015/02/19) field, system has to know how it can get the quarter out of date, so here conversion routine helps in achieving this.

Regards,

Vengal.

[yasemin_kilinc · Accepted solution]

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...

[former_member214415]

Hi,

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

[former_member220628]

Thanks but that's exactly the problem.

In the screenshot posted in my previous replies, you can see that there is no conversion routine in object created. I also tested creating info objects in Prod server.

[former_member214415]

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

[former_member220628]

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

[former_member220628]

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.

[Loed]

Hi Parvaneh,

You may now close your thread by clicking the CORRECT ANSWER..

Regards,

Loed

[former_member220628]

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

[former_member214415]

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

[RamanKorrapati]

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

[former_member220628]

Hi Raman,

Thanks but the source and target fields cannot have the same length.The source is a date field , 8 characters, and the target has 5 characters , smiliar to the 0CALQuarter.

I 've mapped the date field to 0CALMonth and 0CALYear Zinfoobjects too and even though the lengths are not the same , the year month and the year of that date field is easily extracted but not the 0CALQuarter.

If I map the date field to the standard 0CALQuarter, the quarter can be extracted but I need to map it to a ZInfoobject which references the 0CALQUarter.

Thanks

[RamanKorrapati]

Hi

When you map date field to 0calquarter, you may see one standard conversion/function object or some check boc option flagged. observe rule details screen shot.

if you map date to custom object(ref of 0calquarter), you won't see that conversion. manually you may need to maintain it.

so cross check it and use related function(which is given by venal replys)

Thanks

[former_member220628]

Thanks Raman.

In the properties of the custom infoobject referenced to 0CALMonth, I can see the conversion routine PERI6 but not for the custom quarter info object and I can't select a routine manually.

I tested Vengal's work around but I am still curious about the root cause of the problem

[RamanKorrapati]

date field -0calquarter will work conversion automatically. because those are standard objects.

where you mapped date field - zcustom object ,so its not working automatically.

We need to derive calquarter based on date. so vengal reply function works the same.

[Former Member]

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

[former_member220628]

Hi,

Thanks, yes I'm asking why the quarter value is returned as 0. The date coming from ECC is correct.

As can be seen below, the date is valid.