BEx Reporting
232. What are Structures?
a. They are a combination of characteristics and Key figures
(Basic Key Figures, Calculated Key Figures (CKF) and Restricted Key
Figures(RKF))
233. What does the term CELL mean?
a. The term CELL in the function of Defining Exception Cells
is the intersection of the two structure elements.
234. 4 Different types of Variables:
a. Text
b. Formula
c. Hierarchy
d. Hierarchy Node Variables
o Variable Hierarchy Node with a fixed Hierarchy
o Variable Hierarchy Node with a variable Hierarchy
235. 5 Variable processing types:
a. User Entry / Default Value
b. Replacement Path
c. Authorization
d. Customer Exit
e. SAP Exit
236. When we run the query at query run time the wrong data
has come for one key figure, what might be the problem?
a. If the Key figure is Calculated Key Figures (CKF), check
the formula. If it is a regular key figure, check the respective values in the
InfoProvider. If the values are incorrect, need to check the update rules &
transfer rules. If they are correct in the InfoProvider, then do check the
source system table, maybe they are captured in correctly in the Source System
level itself.
237. When we run query at run time it is not displaying one
key figure values what could be the problem?
Check if InfoProvider has values for the same. If yes,
then check the formula incase of CKFs or check the selection parameters/filters
etc in query.
238. Suppress the unit from displaying on the BEX Report
Go into the query where your key figure is.
Right click on key figures in the column section.
Select New Formula
Name the New Formula, Actual Qty
In the function column expand Data Functions & select
value w/o dimension.
NODIM() will appear in the formula. Click on your key
figure actual qty from the operand list.
Hide your key figure in the query and display this new one
(unit free)
239. I have a requirement where in, in the BEx Report I have
to display the date when the report was run i.e. the Current date. Do I have to
make use of VB code for that or is there a simple solution for that. Any
Suggestions?
You can use Variable (type: SAP exit) for the same i.e.,
0DAT (current calendar day- which will be picked up from System date)
I'm not sure if u have to do something in BW for that, but
I have on my reports after they have been run, gone to the File Menu, then
chosen Page Setup, then Header/Footer, click the Custom Footer button, then I'd
select my date and time to appear on the Right section of the page at the
bottom. I've also then saved the workbook as such and that date remained there.
Have you tried using Text elements in the report? If you
click on the "Layout" button, you can then select "Display text
elements" and then "General". This puts in a number of elements
into the report (workbook) The one you're looking for is a text element called
"Last refreshed". It records the last time the report was refreshed
(i.e. the last time it was run).
240. Assume that there is 5 years of data to be loaded as
per the client requirement we need a key figure in the reporting. How to get
historical data to that key figure? Is it possible to load only the current
data instead of loading historical data for a key figure?
When you load, just load it for 5 years. If you want to
see just a current data in the Key Figure just create a Restricted Key Figure
(RKF) with fiscal year (current) or posting period with your current value.
241. When to report from R/3 and when from BW?
We can Report from R/3 for all operational needs that are
based on the transaction data. The optimum use of BW is to analyze the data
from tactical and strategic point of view.
No comments:
Post a Comment