As name suggests they are nested prompts, one prompt after another or i can also say series of prompts which will narrow the end user selection. Prompt values are dependent on previous prompt value (user selected) and only the last value is used in query.
For example: Let’s say we have heirarchy – Country -> State -> City and you want user to select city based of country and state prompt then its time to use cascade prompts. Read more
01. What is loop in Universe? Explain methodologies to resolve it.
02. What is CHASM trap and Fan trap
03. what happens if cardinality are not resolved
04. What are @functions Read more
SAP BusinessObjects Web Intelligence (WEBI) Official Tutorials.
SAP is now offers tutorials for BusinessObjects 4.0 suite of products. New content is added as soon as it becomes available, so check the page on a regular basis.
SAP Business Objects (Old Versions) Upgrade to Version SAP BusinessObjects 4.0 (Aurora)
What is Row-Level Security?
You can restrict user from retrieving data from database based on some column or combination of cloumns is called row level security in Business Objects.
It can be implemented in SAP Business Objects Read more
Variable : Formula with a name.
It can be used with every report feature and can be used anywhere on the report.
The @Variable function syntax:
BOUSER : contains username with which you login. Read more
What do you do when your report needs an input (filter) from user in order to run report. You use @prompt function.
Ex: User does not want to see all 10 years of data that we have in our data mart. Instead he/she would enter or option to select year value before report run.
Prompts can be used to restrict the data or to make large value objects easier to use. You use the @Prompt function in the WHERE clause for an object. It forces a user to enter a value for a restriction when that object is used in a query, or to select a value or a list of values. When the user runs the query, a prompt
box appears asking for a value to be entered.
A function receives zero or more values as input and returns output based on those values.
For example, the Sum function totals all the values in a measure and outputs the result.
Cardinaliries in Business Objects :
I would say it explain relationship between two tables. How are they joined ?
Data in real world is distributed in multiple tables and in order to create report for anyone we need to join those tables. Read more
What is Derived Table?
If you are coming from sql background then i would say “Views”.
For Non-DB guys, it’s a logical table* based on some physical table(s).
It is created using SQL statement with expressions and joins. Read more