If you have multiple tables in your SAP Business Objects universe and you are pulling data from only two table which are linked through intermediate tables then your performance goes down as it would require multiple WHERE clauses or JOINS as it increases Join path. Shortcut Join is a join with alternative path between two tables. Read more
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
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