Question Re: 0FISCPER3 Remodaling Infocube in Technology Q&A

0FISCPER3 Remodaling Infocube

Former Member — Tue, 26 Jul 2016 19:19:02 GMT

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

Re: 0FISCPER3 Remodaling Infocube

Former Member — Tue, 26 Jul 2016 19:55:32 GMT

Maybe Fiscal Variant is needed.

please try using 0FISCPER and let us know

Regards

Re: 0FISCPER3 Remodaling Infocube

Former Member — Tue, 26 Jul 2016 20:31:56 GMT

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,

Re: 0FISCPER3 Remodaling Infocube

Former Member — Tue, 26 Jul 2016 20:45:49 GMT

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

Re: 0FISCPER3 Remodaling Infocube

Former Member — Tue, 26 Jul 2016 20:53:13 GMT

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?

Re: 0FISCPER3 Remodaling Infocube

Former Member — Tue, 26 Jul 2016 21:31:24 GMT

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,

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 07:08:42 GMT

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

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 07:31:14 GMT

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,

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 07:51:22 GMT

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

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 07:56:39 GMT

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

for the second thing No,

Regards,

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 14:42:04 GMT

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

I need to derive values from 0CALDAT to 0FISCPER3

0FISCPER to 0FISCPER3

SOME ONE HELP ME PLEASE.

Thanks

Bhaskar

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 14:49:01 GMT

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

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 15:05:33 GMT

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.

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 18:55:34 GMT

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

Re: 0FISCPER3 Remodaling Infocube

Former Member — Wed, 27 Jul 2016 21:52:42 GMT

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,