Fiscal variant not visible in BEx

[Former Member]

Dear All,

Fiscal year variant is present in 0SD_C01 infocube but is not available BEx Designer.I used Standard SD Reports.It is available in Free characteristics,but it is not in Time dimension.  It  was maintained constant  (K4) in info provider specific properties. And also maintained in T009 table. But still not available in BEx. Please help me with detailed steps.

Thanks in advance.

Cheers

Armadhu.

[former_member182343]

Hi,

Try to create Generic bex query on top of 0SD_C03 and check for 0FISCVARNT.

0FISCVARNT is compounding attribute to 0FISCYEAR.

Check for availability of both in time dimesion of 0SD_C03.

Regards,

Vijay

[Former Member]

Hi,

Where you are not able to find the field in query designer list panel?

If yes Please  check under Time characteristic.

Before that check in Infocube level under which dimension you are able to see fiscal year variant?

But time characteristic should be fall under time dimension only.

[umashankar_poojar]

Hi Armadhu,

             Could you please provide some more information on the issue, it would be better if you attach screenshots of your query and where you are not able to find?

Thanks,

Umashankar