Skip to Content
0
Former Member
Dec 04, 2006 at 09:02 PM

0CAL DAY mapping to 0FISCPER hELP

72 Views

I have a datasource that has the field 0CALDAY and now user want to view the report by fiscal year/period so i will map 0fiscper with 0 calday and automatic conversion will take care in bi 7.0 but what to map to 0fiscvar since i do not have fiscvar field in data source so is it required to enhance the data source to include fiscvar field in data source by picking from table TKA01 - LMONA or is there any thing that can be done with out enhancement in datasource?????

2 Please confirm since datasource pick up the Transactional values from table VIBDMEAS. AND THAT table does not contain 0fiscper and 0fiscvar so I pick up the fields fiscvar field (0fiscyear) from any other table like TKA01 OR T001 - PERIV

Where other transactional values fopr datasource are not there will it still work

to add fields fiscvar field (0fiscyear) from any other table like TKA01 in the datasource and will that solve the purpose??????????

Please help me sooon

Thanks

Soniya