is there any mistake in time dimension(attachment)? can u pls help me?

[former_member225916]

Hi all,

Can u pls help me?

I just need fiscal year from April.

Thanks and Regards,

Naidu

[Former Member · Accepted solution]

Hi Naidu,

I believe the PARENTH2 is for the FY hierarchy. In that case, the parent of FY2013.APR should be FY2013.Q1, and so on so forth.

Hope this help.

[former_member225916 · Accepted solution]

Hi Nilanjan,

Thanks.

suppose if i submit the data for 2013.JAN, can i get the same value for FY2013.APR ??

Thanks and Regards,

Naidu

[Former Member · Accepted solution]

Hi Naidu,

This wont happen automatically, unless you put some logic in the system.

[former_member225916 · Accepted solution]

Hi Nilanjan,

Thanks

[former_member186498 · Accepted solution]

Hi Naidu,

if you want automatically filled the FY data then you must add code in the default logic that will be executed after every send data or write a script if you want to run it on demand.

Kind regards

     Roberto

[former_member225916 · Accepted solution]

Hi Roberto,

I am new to script logic. can you help me on this?

Regards,

Naidu

[Former Member · Accepted solution]

Hi Naidu,

Just for reference,

*WHEN TIME
*IS 2013.JAN
   *REC(TIME = FY2013.APR)
*ENDWHEN

However, practically speaking, from solution perspective, the base level members should be the same for both the hierarchies. You just need additional members for the parent nodes (Qs, and TOTALs). In PARENTH1, all the 12 months will roll up to Qs anf TOTALs as per the Calendar Year. Whereas, in the fiscal year, the same 12 months should roll up to FYQs and FYTOTALs. With this approach, you dont need an additional calculation to transfer the data.

Hope this helps.