0FISCPER3 Remodaling Infocube

[Former Member]

Hi All

I have to add 0FISCPER3 to cube in time dimension and this new field needs to derive value from 0CALDAY which is also in same dimension.

But when i apply remodeling rule I have got error " Info object 0FISCPER3 cannot be filled with 0CALDAY"  and when I checked both objects in RSA1 their data types are different so Is there any better approach to resolve this issue.

As per user requirement I should derive 0FISCPER3 value from  0calday.

PFA -

Thanks

Bhaskar

[former_member210321]

Hi,

The time conversion wont happen automatically as done in the transformation, for it you need to apply a class with an ABAP code to do the conversion of time. On the link below you can find the steps to use the class:

Remodeling process in BI

Regards,

[Former Member]

Can I use like below in Remodeling page and map the 0CALDAY -> 0FISCPER3 at transformation level.

Will it work?

Is it mandatory to select one of options below under "Using" option?

[former_member210321]

Hello,

As i said earlier in Remodelling automatic time conversion for 0CALDAY -> 0FISCPER3  is not possible, you have to use the option CUSTOMER EXIT and follow the steps as mentioned in the document attached.

Then on the transformation level map the 0CALDAY -> 0FISCPER3 directly.

Regards,

[Former Member]

Hi

Thanks for update.

If I mapped at transformation level is it required to

Write customer exit code at remodeling level.?

Please let me know if any other process to achieve this without writing ABAP code.

Thanks

[former_member210321]

Hi,

Using Remodelling option is to loading historic data for the new infoobject, in your case you want to add 0FISCPER3, through remodelling process the historic data for this field is obtain through user exit.

Secondly if you add the new infoobject to the infocube and you do not need the historic data for the new field than in the transformation map it directly (no need to do any ABAP code) so as to obtain data whenever there is a daliy load.

Regards,

[Former Member]

Great Asia ,

In remodeling historic data will update through customer exit only or other all options like 1:1 mapping.

In second case if I map it at transformation level from 0calday -> 0fiscper3 also is it required to map 0fiscvarnt to 0fiscper3.

Thanks

[former_member210321]

In Remodelling objects are updated with all options, for your case it should be customer exit.

for the second thing No,

Regards,

[Former Member]

Hi 

Could you please some one help me on writing ABAP code at Remodeling option.

I need to derive values from 0CALDAT  to 0FISCPER3

                                                          OR

                                        0FISCPER to 0FISCPER3

SOME ONE HELP ME PLEASE.

Thanks

Bhaskar

[former_member210321]

For 0FISCPER to 0FISCPER3 you can do 1:1 mapping.

[Former Member]

It is not allowing throwing same error Asif .. When I checked in system 0FISCPER3 is display attribute to 0FISCPER so can i use it directly  using "Attribute of character" option.

[Former Member]

I have used attribute of Characteristic option in remodeling and it's completed successfully. below is the output after remodeling 0FISCPER3.

Transformations are deactivated after performed the Remodeling so I will activate it manually but my doubt is what rule i need to apply  for newly added characteristic 0FISCPER3. ??

[former_member210321]

Hi,

Yes you have to activate it manually transformation and if use DTP. Regarding the mapping for the newly added characteristic you dont have to appy any rule you can map it directly from 0FISCPER.

Regards,

[Former Member]

Maybe Fiscal Variant is needed.

please try using 0FISCPER and let us know

Regards

[Former Member]

Where can i include  Variant , in Remodeling page the option is not available.