-
-
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 &...
-
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...
-
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...
-
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 ...
-
Can we save or create more than one universe in one repository.
anil
- Mar 13th, 2007
Yes, u can more than one universe in the repository..which different names.....
-
Can we open the full cleint reports on thin cleint and vice verse?
dileepv
- Jan 6th, 2010
Yes, we can we need to convert the deski (full client) to webi (thin client) using report conversion tool, but not vice-versa (webi to deski)
Revansing
- Nov 25th, 2008
Straight forward answer is NO!!!!!If you needs to view the reports any how would have use report conversion tool to convert it into .wid and? vice versa but again it has limitations like the function...
-
What is the difference between derived tables and a view? Which one gives better performance ?
Pradeep Mishra
- Jan 7th, 2010
Yes, it's too good.But One more thing is there , We can use The @Function (@variable,@Prompt) in the derived Table ,but we can't do the Same thing in the Views.So you can say that these are benefits are in the Derived Tables.
pat.mclean
- Mar 23rd, 2007
Hi !Just an addition, 1. Views play all their rollups at database level. Derived Tables will fetch values into BO's microcube & then will perform the rollup calculations, resulting more proces...
-
How to join two reports in for webi when they are on two different tabs?
jemimaplatina
- Jan 13th, 2010
Data from two different tabs can be merged using the merge dimension fuctionality in BO. When a report is generated with 2 queries BO automatically merges the common dimension and then gives the resul...
Sunil
- Jun 3rd, 2007
We can use Merged Dimension option Available in Reporting Bar.
-
BIAR Files
What is BIAR Files? What are its use?
vinayakgole
- Jan 14th, 2010
BIAR Files are Business Intelligence Archive Resource files. These files are used by BO to store content in the enterprise system which can also be moved across environments. So if you have to move a file from development to production,it goes across as a BIAR file
-
Web Intelligence
What is Web Intelligence?
vinayakgole
- Jan 14th, 2010
Web Intelligence is the Business Objects application that run over the inter or the intra net. The product is java based and hence does not require individual licenses as with Desktop Intelligence. Yo...
-
Restriction on Max Rows
How can you restrict max no. of rows returned to a document?
RishiBO
- Jan 18th, 2010
You need to go to the Related Universe-->Universe Parameters-->Controls tab this controls settings allow you to limit the size of the reulst set and the execution time of queries.
-
Link Between Datamarts
How to link between Datamarts?Which tools are used?
RishiBO
- Jan 18th, 2010
We can create a link between Data Marts by making use of ETL (Extraction Transformation and loading) Tool?job
-
Hierarchies and Conditional Objects
How to create hierarchies and conditional objects in the designer?
RishiBO
- Jan 18th, 2010
Hierarchies: Go to the Tools option in main menu and select Hierarchies here it allows you to set up dimensin hierarchies for multidimensional analysis.Conditinal Objects:Go to the Filter option down in universe window here you can create condition objects just like the objects.
-
SQL Button Option Access
How to give the SQL button option access from Business objects 6.5?
RishiBO
- Jan 18th, 2010
Go to the Supervisor-->Select the user and the applicatoin-->Properties of the application Here you can enable or disable the access.
RishiBO
- Jan 18th, 2010
Go to the Supervisor and select the user then go to the properties of the application then you will find the command restriction dialog box controls security command settings. Here we can enable the SQL Button Option Access
-
Get data from two data providers
How to get data from two data providers?
RishiBO
- Jan 18th, 2010
Linking a data provider to another data provider in the Deski Reports Select the dimension to be linked in the Data Providers box. Select the Definition tab. Click Link To. The Define ...
amaresh1981
- Sep 10th, 2009
There is a concept of Merge Dimension in BO 6.5. By using Merge Dimension we can get two data Providers data in a single report.Merge Dimension can be done by merging the only dimesion object with the same data type.
-
Apply Global Filter in DeskI
How can we apply the global filter in Deski of XI r2?Is it available in WEBI of XI r2?
RishiBO
- Jan 20th, 2010
Add to the above AnswerGlobal filter is the option which is there in Format(Main Menu) Filter option: The Filters dialog box allows you to filter the data returned by a variable. There are two types o...
muralikrishna1982
- Aug 24th, 2008
Global filter is nothing but filter applied at universe level this can be called as a condition.after u export the universe to the repository it will be made available to the report devolopers. this is available in web in xir2
-
Sub Reports within Report
How can we apply sub reports within a reports?
-
Apply Global Filter
How to apply global filter?
RishiBO
- Jan 20th, 2010
Add to the above AnswerGlobal filter is the option which is there in Format(Main Menu) Filter option: The Filters dialog box allows you to filter the data returned by a variable. There are two t...
muralikrishna1982
- Aug 25th, 2008
you can apply filter with in the designer only. It is the universe designer who can apply global filter so that the amount of data to be returned while running a report can be simplified at the univer...
-
Cascading Prompts
How to set cascading prompts in a report?
RishiBO
- Jan 20th, 2010
Adding to the above point.For applying Cascading prompts :Goto the Universe in Tools select Cascading list of Values, from here we can give cascding prompts but this is not avilable in 6.5
amaresh1981
- Sep 10th, 2009
Cascading prompts are nothing but the Nested Prompts. We can create the cascading prompt by using following Steps.- Select an Object and and edit the properties of the Object- Then Impose another Prompt as condition
Business Objects Interview Questions
Ans