-
Aggregation
Can anyone tell me about 1)aggregation at microcube level2)aggregation at database level
devgod
- May 23rd, 2009
Aggregation can be of the following type: Table Level: Commonly known as Marts.L1/L2 marts at monthly/yearly levels. Query Level: Make use of Database aggregate functions like SUM, COUNT, MAX, M...
Rajnish_kaushal
- Apr 13th, 2009
Aggregation : In SQL we have functions e.g. Sum , min , max , count etc for aggregating the data. We can use these functions to create objects in universe for aggregating at database level. Also when ...
-
Category and Folder Difference
What is the major difference between a folder and a category......when both are for organising the documents
Rajnish_kaushal
- Apr 13th, 2009
For interview purpose one line answer is " Categories are Logical way of structuring the contents. But Folders are logical and Physical way of structuring the contents. Contents belonging to cate...
sreenivas27
- Aug 10th, 2008
Hi,Content in BO enterprise can be organized into folders and categories.Folders are the primary method of oraganizing content.Every report or document must reside in a folder.Areport or document can ...
-
Cross Tab and Tabular Report
What is the difference between Cross Tab and Tabular Rreport?
hari7878
- Sep 10th, 2008
Cross tab:1.Cross tabs are three dimensional grid.2.Cross tabs are provides essential information for analysing the data.3.These are applicable for more than two filedsTabula:1.Tabular reports ar...
sreenivas27
- Aug 10th, 2008
Hi Cross Tab reports analysis like 3 dimentional Tabular report u can analysis 2 dimentional ...
-
CMC and CCM
If we can manage the servers using Central Management Console(CMC), why is there a separate tool Central Configuration Management(CCM)?
Read Best Answer
Editorial / Best Answer
Rajnish_kaushal- Member Since Apr-2009 | Apr 13th, 2009
CMC and CCM , both have some common features and they are as you mentioned. But there are some unique things which you can do in one and not other.
CMC
You can set what need to be audit in individual servers.
You can enable auditing in CMC only.
You can set metrics of individual serves in CMC only and not in CCM.
You can see how many sessions are live only in CMC and not in CCM.
You can see how many requests were received , processed , failed only in CMC but not in CCM.
You can create server groups only in CMC but not in CCM.
CCM
You can only cluster and decluster servers using CCM.
You can only configured Auditing Database in CCM and not in CMC. You do configure individual servers in CMC but main work of configuring audit database is done in CCM.
Last but not least. CMC is web based server application. If your web server is down and you want to cring other servers up and running, you can only do in CCM.
Regards
Rajnish KaushalBlackmoon
- Aug 29th, 2009
CCM is separate tool for server management tool. CMC is overall management tool which is web based tool we can manage from anywhere. and we can not start/ stop / restart the CMC server from CMC.BOXI...
Rajnish_kaushal
- Apr 13th, 2009
CMC and CCM , both have some common features and they are as you mentioned. But there are some unique things which you can do in one and not other. CMC You can set what need to be audit in individual ...
-
Universe CMS server Migration
Hi AllPlease Me onhere we are working onsite and offshore development report offshore maintaining one universe and onsite have same name but different databases ,can i merge to Universe
Rajnish_kaushal
- Apr 13th, 2009
If you are doing development offshore and then migrating the universe onto onshore then following recommendations.XI Release 1/2/3Migrate your development using import wizard. Create two connections o...
prashantpurohit2000
- Mar 6th, 2009
Hmm in your case database of both universe is different. If you want to make them identical, just create a one new copy of database at any side to make the database look replica of each other on onsit...
-
Create Dashboard
How to Create a Dashboard?
-
Row Level Security
How do you implement row level security and where do you implement?
-
-
Why do we use crystal reports when we have reporting tools in BO itself?
lionskashif
- Aug 28th, 2012
To my Understanding Crystal Report is older then Webi and it has more user friendly Connection available compare than webi. Custom formatting, Wide range of Variable, Predefined Filter, Printer and etc.... It usually use for Transitional data.
kiran
- Feb 29th, 2012
In WEBI we don't have add command option ,in crystal report we have add command option.
-
Prompt format change
how to change the date format in Prompt ie dd/mm/yyyy to mm/dd/yyyy?
sapna
- Aug 29th, 2017
Formatdate(UserResponse("Select Start Date:"),"mm/dd/yyyy")
-
Performance tuning in universe
How to create reports in universe easily?
-
When do we need to use 2 or more data providers to make a report??
Sapna
- Sep 4th, 2017
When we have either two different database or two different universes.
prashantpurohit2000
- Mar 3rd, 2009
You should use more than 1 data provider when you feel that you need different data set to design your report properly. These data providers can be from different database/universe or same database/universe.
-
How achieve the many to many relation ship in Business Objects...
ASHOK1324
- Apr 19th, 2009
In BO universe designer, Drag the column of first table to the corresponding column of second table or simply go to Insert->Join to create a join between 2 tables. You can change the cardinality fr...
MrExpert
- May 12th, 2007
You can achieve? this by creating two data provider having one field common and linking them using?the property?in 'viewdata'
-
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 &...
-
How to break a Date field into Year, month, week,day?(For example: I have a field INVOICE_DATE. Now i want to break it as Year, month..... i.e. in time dimension.) DO i need to have some changes in Universe?
prashantpurohit2000
- Mar 4th, 2009
No need to change the universe, create some report level variables like:Year =Year([Date]), Month =Month([Date]), DayNumber([Date]) etc, but if you want to only show them differently just change the dateformat of the cell.
sreenivas27
- Jul 1st, 2008
Hi,Just you have create Variables like year, month, week and day base your objects so that you can use these variable and you can do what your.Regards,Sreenivas.
-
What if a cartesian product pop up block appears when running a report. Does it give wrong values? how to solve this issue?
lionskashif
- Feb 2nd, 2011
The Problem is in your schema. Please check your joins, and cardinalities
also check loops.
Whenever cardinalities is not set proper its give you three types of error.
1-->Incompatibility result
2-->Ambigeous result
3-->Cartiesum result
narmadac
- Feb 17th, 2010
To prevent cartesian product when running a report initially you can set it in the Universe Parameters.File ----> Parameters ----> SQL tab ----> two options for Cartesian products 1) Prevent 2) warn (default) -----> click any one of them and then OK
-
What is the difference between break and section in Reports.
lionskashif
- Feb 19th, 2011
Break is applied on whole block it gives you row at the bottom of block for subtotal. It breaks a whole report into the smaller groups according to your select column. When you apply a chart...
sheriey
- Dec 4th, 2007
Strong>Break All the data remain in one block but you can divide the data on the basis of groups
-
How Can We Restrict a database connection to a particular user? what i want ask is, particular connection should user only by that user when creating universes, no one should use that connection, how can we do that?
nishamakhija21
- Nov 10th, 2008
HI,I m talking about BOXIR2 version.you can restrict the Connection access to specific user by applying the restrictions on the user rights using CMC.Log on in CMC--> Go into Connections--> sele...
ranjoy7
- Jun 19th, 2008
The secured connection is not meant for share. the user who create the secured connection can access it.
-
What is a Thin Client Report? Please Explain
Anupam Ghildiyal
- Jun 9th, 2011
Basically, Thin client is web based application and most of the processing done on server side. Thick client is installed into client side, it is still connected to server but most of the processing ...
lionskashif
- Apr 2nd, 2011
being a Developer you are creating a reports and End user want to see that report and they dont have BO installed in his laptop. So, BO administrator provide web link which is besically a infoview lin...
-
A Business Objects Universe consists of classes, within each class are objects, name and describe the three types of objects.
wadate
- May 14th, 2011
There are three types of an objects: 1:-Dimension Object: An object being tracked in multidimensional analysis; the subject of the analysis. Dimensions are organized into hierarchies. 2: Det...
lionskashif
- Feb 1st, 2011
OBJECT: An object is a named component that map to data in the database.DETAIL: Provides descriptive data about dimention. A detail is always attached to a dimention.MEASURE: contains aggregate functions that map to statistics in the database.
Business Objects Interview Questions
Read Best Answer
Ans