Question:
Hi Reporting Gurus,
I am on ver 3.0B. and have a specific reporting requirement in BEx
I need a heading like
Period YTD
Cost center GL Account Actual Budget Actual Budget
Now, how do I get a header like Period and YTD as shown ?
Also, how do I achieve a page-break at new values of Cost center or GL account.
Thanks,
Harvinder
Answer:
What do you mean by as shown? If you mean as shown in the query, you can use text variables to fill the information that you need.
Answer:
Hi JLaruss,
I need a heading like
Period YTD
Cost center GL Account Actual Budget Var Actual Budget Var
where within Period, I have Actual and Budget and Variance columns and similarly, within YTD I need Actual, Budget and variance columns.
I hope I am clear this time. Basically, this is a formatting issue
I also am not clear how you will use text variable to achieve this.
Can you please elaborate ?
-Harvinder
Answer:
Helo Harvinder,
I try to explain it step-by-step (sorry if it's to detailed)
1, Create a new structure in the columns
2, Drag-and-drop your period infoobject (0CALMONTH or 0FISCPER) into this structure (I will call it 'Period').
3, Right-click on Period, and restrict to your period (with variable or constant)
4, Drag-and-drop your period infoobject again into this structure (I will call it 'YTD').
5, Right-click on YTD, and restrict to the specific time interval (with variable or constants)
Now your first row of your column is ready. Let's move on to the 2nd row.
6, Drag-and-drop your key figure to your column (it will create a Key figure structure)
7, Right-click on this KYF and restrict to Actual values (with Valuetype, Version or the infoobject you have)
8, Drag-and-drop your key figure again into Key figure structure
9, Right-click on this KYF and restrict to Budget values (with Valuetype, Version or the infoobject you have)
10, Create a calculated key figure with the two KYF defined above into your Key figure structure.
And that's all. It should work - it works here. If it's not I must have mispelled something
Hope this helped,
gerist
Answer:
It did help.
Thanks Gerist.