-
How do link two tables in Business Object?
mudit0506
- Dec 28th, 2009
Http://www.geekinterview.com/question_details/53973 The Question 6 has a better answer.Though its more specific to having an Outer Join but it tells you about creating Joins too.
arunabala
- Feb 20th, 2008
do u want to link two tables or two universes, please speicfy the questionIf u want to link two tables means just through cardinality we can join, that means we need to check when the two tables have ...
-
How do you implement Left Outer Joins in the universe
kirantcs1
- Dec 21st, 2009
If you have Table1 and Table2 and you want all the records from table1 and the matching records from table2. Then we put the out join on table1 which is called left outer join. if we put the outer joi...
-
Apply HTML Tags
How to apply HTML tags in a report?
vinny.jus
- Dec 9th, 2009
Using Html tags we can create links to websites based on Object values. This can be done from Designer, DeskI and WebI. To do this let us take a company object,that has values Sap, Microsoft,Oracle an...
-
Product date salesp1 20/Jan/1999 100p1 20/Feb/1999 200p1 20/apl/1999 100p1 20/DEC/1999 50p1 20/Jan/2000 100p1 20/mar/2000 500now i want query like product ,sum of actual year ,sum of business yearp1 450 750here actual year means 1 Jan 1999 to 31 st Jan 1999business year means 1 st APR 1999 to 31 st mar 200pls give me answer as early as possible..
vuongti
- Dec 2nd, 2009
Here is the sql scriptselect product,Act_year = (select sum(amt) from tblProd where Date between '01/01/1999' and '12/31/1999'),Bus_year = (select sum(amt) from tblProd where Date between '04/01/1999' and '03/31/2000')from tblProdgroup by product
Yathish Uppala
- Oct 10th, 2007
I am providing query(oracle) below.Plz go through it.SELECT SAL1.PRODUCT,SAL1.ACTUALSAL,SAL2.BUSINESSSAL FROM (SELECT PRODUCT,SUM(SALES) AS ACTUALSAL FROM PRODUCTS &...
-
-
LOV in BO Reporting
If a user wants to report a list of values that is not available in the Universe/DB, then how will you help him/her to use it in a report?
mani14dec1984
- Nov 9th, 2009
There is one way to incorporate LOV for this problem.1) In Universe In Universe designer Goto Tool >>List of value>> Edit Lov. Select the object in which you want to associate the LOV then check ...
54446
- Sep 17th, 2009
Strange but not immpossible.You have to create a dataprovider by selecting others-->personal files.Now, you have to create a dummy object and when you are using that?in BO reporting then add that to filter panel and go for query results of dataprovider, then you can take that?and proceed.
-
CMS Backup
What are the steps to be followed to take backup of CMS?
mani14dec1984
- Nov 9th, 2009
For taking Backup of CMS or BO system there are two ways1) Replicate the Source environment using Import wizard to other system(test/dev/backup)2) Using CCM take the backup of CMS database and also File system
ankur4545
- Oct 3rd, 2009
If you use copy datasource option, you also have option and advantage of copying the source cms db to any other db like Oracle, mySQL, MSSQL, Sybase.(irrespective of what is the source db)cheers!Ankur.
-
BOUSER and BOPASS
What is BOUSER and BOPASS? Why do we use this?
Sivakami_Plr
- Oct 29th, 2009
BOUSER gives the username of the currently logged in user. This can be used in @Variable functions in designer to dynamically apply restrictions based on the user logged in.
-
How can we project the results of the two data providers in a single table? What is the process of merging two data providers?
Sivakami_Plr
- Oct 29th, 2009
In Webi - we can merge common dimensions from both DPs and then use them to show the measuresIn deski - We need to link common dimensions using Data Manager window.
-
Restrict Data Based on Column Values
A report is accessible by 3 user and 1st user should only see the sales data of city A, 2nd can see only data of city B and 3rd user can see only the sales data of city C. How will you restrict data based on column values?
Sivakami_Plr
- Oct 29th, 2009
This can be done by applying row level security on CITY object. Create 3 restriction sets that limit access to respective city. Apply each restriction to each user.
-
Desktop Intelligence and Web Intelligence
What are the general differences between the desktop intelligence and web intelligence
vamsi.reddy21
- Oct 20th, 2009
Desktop Intellignce is 3-tier architecture (Full client), where as Web Intelligence is 2-tier architecture (thin client).
Sowmya Viswanath
- Jun 12th, 2009
1. Desktop Intelligence 2-tier architecture known as full client. Web Intelligence is 3-tier architecture known as thin client.2. You have install BO for Desk-I , where as web-i can be accessed throug...
-
Database Error while running query in Webi.
When I try to run query from Webi, I get an error of this kind:The database error text is: {error_db}. (WIS 10901)I'm using SQL Server 2000 DB and driver is ODBC.It is not retreiving data to the report.Somebody please help me to resolve this issue.....
tgmurugan
- Sep 29th, 2009
Have you created a DSN on the server (If using SQL server) or an entry in the TNSANAMES.ORA file for Oracle? Also make sure the ODBC connections are named exactly the same. "MS_ACCESS" is not the...
-
Linked Universes
What are linked universes? Have you worked with them, problems faced and solutions?
Ankita_Anand
- Sep 23rd, 2009
Linked universes are for the purpose of sharing componets among universes to save on development time and ease of maintainace.When you link two universes, one universe has the role of a core universe,...
ganesh.hbad
- Apr 17th, 2008
Linked universes are universes that share common components such asparameters, classes, objects, or joins.When you link two universes, one universe has the role of a core universe, theother a derived ...
-
How can we migrate BO 6.1 repository to a multi schema database?
We have three different repositories on different databases. No we want to move all the three to single database by creating three different schema's.
prakharrajsingh
- Sep 19th, 2009
Though it is more of a DB migration centric question rather than BO repo migration.It depends completely on which Db is being used and what would be the target DB.in SQL Server you have to maintain se...
-
BO Universe Data Providers
What will happen if you use objects from two different DataProviders from two different universes?
54446
- Sep 17th, 2009
If you are using two objects/variables from two different dataproviders and if that is a dimension then you will not able to drag that object/variable into the report that will automatically hides its...
-
Templates
I have saved my reports in to a category. Now i want to modify all the reports with the same change. So how can I change all the reports at a time? If I want to use a template, how can I apply it to all the reports at once?
54446
- Sep 17th, 2009
Yes after creating report also we can apply template which you wanted to apply but one report at a time at desktop,Go to Format-->Report-->Apply template.You will go to all report template and also you have a browser to your own template.
Rajnish_kaushal
- Apr 13th, 2009
If I have to reply to this question, I will reply as "It is shame business objects do not have templates. but at the same time, if we start creating templates we will end up creating number of differe...
-
ERRORINF
while running the report in infoview i am getting this error 'ERRORINF' can u tell me when will u get this error.
54446
- Sep 17th, 2009
Assuming that universe is also available in XI with a secued connection else make the same connection test it and export that to reporsitory,This also occurs if TNS is not present in TNS file. Then?p...
mri_sonam
- Dec 31st, 2008
After migrating from BusinessObjects 6.x to BusinessObjects Enterprise XI, opening or refreshing Desk Intelligence document with prompts in InfoView causes the following error message to appear: "...
-
Business Objects Basic questions
Hi Friends,I have some questions to be cleared , plz give me reply to my mail id......1.What is Business Objects Auditor and what we can do by using Auditor?2.How to use SAP data provider as data source when we are creating reports?3.what is dashboard and at what situations we will use dash boards?4.what is performance manager?5.what is the use of importing wizard in B.O XI?6.how to migrate Desk Intelligence,...
boe_123
- Sep 15th, 2009
1. For user statistics 2. In the designer, while creating a new connection, choose SAP client 3. Dashboard is a tool for visual representation of processes and performance. used for What if analysis 4...
-
Crosstab Reports
In a cross Tab report, will you be able to insert a column on the right side of the report? If yes, then how will it behave?
boe_123
- Sep 15th, 2009
Yes,we will be able to insert columns if the columns are compatible.If we insert a detail/dimension,for each value of the column a new column appears.If we insert a measure then we should ensure it ha...
smghurde2
- Sep 10th, 2009
A coulmn can be entered in crosstab report, however it will insert seperate column for each value of columns.
-
How to filter repeatative values in the report to get distinct values.Example: In any database we can use distinct command But My Report source is flatfile.Therfore,I cann\'t manipulate source system. Is there any command or function to filter repeating records/values in the report.Advance,Thanks.BO-Nath
smghurde2
- Sep 10th, 2009
I suggest you use the break function as it filteres the distinct values.Hope it help,NEAL
Omkar Paranjpe
- Mar 18th, 2006
Hi,One other way possible is by doing "No Duplicates" radio button in the Options of the data provider in the Definition(the black cube)But sometimes in free-hand sql reports it is not possible.
Business Objects Interview Questions
Ans