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.
