Skip to Content
0
Former Member
Dec 05, 2006 at 05:14 PM

Chars in columns for Input Ready query

27 Views

Hi

Hope every body is just doing fine. I am puzzled with following doubt when compare BPS layout builder to IP input ready report. Please help me to clear some smoke here.

We have a simple input ready query to enter some values in the key figure for given combination of characteristics for 12 fiscal year periods in the year.

BPS >>> In BPS manual planning layout we would have selected the Key figure and Fiscal Year Period in data column and profit center and Plan Year in Header and Other characteristics like GL account,cost center in lead column so that we can hide the Fiscal year period by restricting the values of key figure for particular fiscal year period value while creating columns in Data columns like Jan 07. etc

IP>>> So in IP, I have fiscal year period in aggregation level with all other chars and key figure. In input ready report, I have used the structure to pull the key figure and fiscal year period value to come up with column and not included the key figure in rows or columns of report but when I was executing the query system is automatically including the fiscal year period as free char. I am puzzled on how this is going to work. Is fiscal year period not populated automatically based on column.

Your inputs are highly appreciated with point.

Thanks,

Raj.