Can we overwrite the SQL query after creating the report
Yes you can overwrite the Query in Webi,but with restriction. please note that free hand sql in not supported in Webi, all you can do is play around with the Where clause, or change the select conditi...
Yes, My Man you can write or overwrite SQL in Webi. Go to Edit Query and On your left top you will see the SQL Icon. Click on it window will open along with gray out. If you want to read that OK or i...
In BO XI 3.1 universe designer... File> Parameters> link tab... add a universe..
Business Objects Designer is a software tool that allows you to create universes for Web Intelligence and Desktop Intelligence users.Designer provides a connection wizard which allows you to connect t...
How to debug the universe in designer module
Tools>Integrity Check...
When to use local filter and when to use GLobal filter?
Local filters define at report level whereas global filters are define at universe level.
Local filter apply on particular report (one table), global filter apply all the table in one tab.
What are the different types of filters available in business objects?
we have three kind of filters;
1.universe level filter
2.query level filter
3.report level filter
Query filters
Report filters
What is #multivalue and #syntax error in business objects
I need full example of #multivalue error............how the errors r coming..............n how to solve that errors
Multivalue error will occur when more than one row comes for one cell. to avoid this issue you have to use Min(), or Max() as per your requirement.
Syntax error will occur when available improper formula used in the report. so you have to correct it first.
Can we have both drill and hyperlink working on same column? Explain
No We cannot apply both simultaneously. If we want apply Drill and then Hyperlink only Hyperlink will be considered.
Yes, we can apply drill and hyperlink in column. First apply drill and then select the column to which you want to apply hyperlink. Right click on the column and select option hyperlink.
What is a section in a business objects report?
Section provide the analysis in sub group vise, suppose we have thee column country, region, revenue, if we apply section on country the table structure change (table structure not change in break) an...
Section divides the Report in various parts based on the simillar entities.
If we want report for US and France Seperately, we can apply sections to view different reports for both.
How do you link different data providers in a single report?
We can link different data providers in a single report by merged dimension.
Use the merged dimensions to link the data providers. It will give you a dialog for the selection of the dimensions in both data providers. select the dimensions which are alike and merge.
What are the user requirements in a universe?
We have to go for 80-20 rule. It means understanding the user requirement first, database, connection secured, table map, join, cardinality, loop, trap, if need then for performance issues we have to create (aggregate, aware,index,derived table,short cut join) test universe
Universe is used for Importing tables, Creating classes, Creating objects, Creating joins, Loops, Fan trap, Chasm trap, Creation of hierarchies, Dimensions, Filters, Breaks, Sections.
What happens to business objects report if the cardinality is not specified??
Without cardinality we have trouble to solve problem of chamtrap, fantrap.
Cardinality used to Relate the Schema in tables. So if there is no cardinality, forms the errors like duplicate data comes into existence.
Please explain about alerts in bo's, under what situation we need to use alerts
Alerters used for to remind/to alert about something that for your specific point of view.
Alert Basically provide your attention toward something you want on it. like you are analysis the Revenue associated with City and Department and you dont want to check all the report total till end. ...
What is a derived table in data warehousing?
Derived tables can define the suquery of a Table. derived table has a query in the form of Logical tables in designer to accomplish task by writting query in query panel.
Derived Table is a Virtual and Dynamic table in schema. It is not a Physical table but Act like a Physical table. why we make that? We can create/store most usable Dimension in it to reuse frequently ...
What is difference between custom hierarchy and report based heirarchy?
Custom hierarchy is used in Scope of Analysis, we can decide the hierarchy as per requirement. For e.g. if there is a hierarchy Year
Report Based Hierarchy is a by default Hierarchy which Designer created in Designer by making a Classes and Objects. Custom Hierarchy is your choice just like you have Dimension year, Quarter, Month,...
What is the chasm and fan traps in business objects
It is common Universe problem when you start to built schema to the scratch. Loops & Traps. Loop: it is the close join path circle where you cant out with resolving the loop. In this case you would h...
Chasm trap The Chasm trap occurs when two many to one joins converge on a single table. For example a customer can place many orders/and or place many loans. Fan trap The Fan trap occurs when a one to...
How does the hierarchy and scope of analysis helps in reports. How does these both gets related.
There are 3 types of Hierarchies in Universe Design. 1- Time Hierarchy: it represents like Year, Quarter, Month, Week, Day. 2- Geographical Hierarchy: It represents like, country, State, City, Town ...
Hierarchy, is set at universe level and there are two kinds: Natural and Custom Hierarchy. Hierarchy is the order of the objects you want to drill through in the reports, say, for example, Time Hiera...
SAP bobj multiple data sources
If we have two data sources and we have to take two tables form each source and generate one report. how to do?.
For acheiving this result. You should have at least one common dimension in both Data Provider and data type should be the same. Then you need to click on Merge Dimension icon from menu bar and Dilou...
Two data source which has two table has to be merged with a common dimension,then build the report
What is the difference between qaaws and live office?
Qaaws : As you know Query As a Web Service. It is generate the URL for using in Dashboard to access report data as a Data Source.
Live Office : Bessically is a technique how to connect Dashboard with your different data source through Excel. It can be Webi, Crystal, Excel etc... file.
Qaaws is nothing but a query as web service,when you are generating report in Qaaws at that time one URL can generated that URL can send to the end user.Live office is nothing one of the connector in ...
How to create predefined filters in bo
when you have a restriction and you dont want to bound the variable or Object then you need to make Predefine filter in Universe. For example. you have city Object and there is couple of people using ...
There are 4 filters
Pre defined filters
custom filters
prompts filters
quick filters
Pre defined filters are created at the Universe level.In the Universe window,select the object,right click ,select condition then enter the condition name and filter conditions
This contains the data retrieved from database. when we run a query against the database in the report the resulted data would be stored in the microcube.
Like WEBI, we can choose our needing fields and become a new query, then we can use our creating microcube for the report.