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
Display summary Information (SUM) not the detail (table) on business object desktop Reporting – Deski
1. Insert a break on the column of your choice.
2. Right click and select Format break
3. Select “Fold” option (checkbox)
and this will do the magic.
Just came across awsome article written by Dave Rathbun for the beginner and especially if they come from a spreadsheet background where everything is right up in front. Read more
I broke report in multiple sections. ex:
Account 001 $100.00
Account 001 $120.00
Account 003 $100.00
Account 930 $53.09
Account 001 $50.00
Account 043 $34.09
Account 930 $454.98
How can i add a column which will give me total sum based on Account number. Ex: I need total count of Account 001. Should be $270.00
Account 001 $100.00 $270.00
Account 001 $120.00 $270.00
Account 003 $100.00 $100.00
Account 930 $57.00 $500.00
Account 001 $50.00 $270.00
Account 043 $34.09 $34.09
Account 930 $443.00 $500.00
Answer: FOR EACH … IN REPORTS .
EX: =CountAll(<Account Name>) ForEach <Account Number> In Report
Detail Objects : A detail object is represented by the pyramid icon and can be viewed by clicking the + plus to the left of the dimension. Read more
Count and Count All functions display how many records are in a report. However, there is a big difference between the two functions: Read more
Business Objects File Extensions:
*.bqy = Business Query Files
*.key = Bomain file
*.lov = List Of Values query
*.lsi = local security information Read more
There are 3 different types of BO connections.
Personal : Can only be used on client
Shared : Can be used by more then 1 user on shared server
Secured : This connection is used when you wish to distribute the completed universe to the user via repository.
A default hierarchy is created with a dimension in the order in which they are presented in the class. By default one class having one hierarchy i.e called report hierarchy. Read more
In the BO universe, how to link two universe ex: 1.region.uni 2.marketing.uni
There are two ways: Linking universe & Including universe
Linked Universe : Changes to the original univ will reflect in Linked universe. You can not edit any thing of the univ which was linked. Read more