Vishnu Kiran: October 2012

1. What is an Universe?

2. How many Universes did you create?

3. Tell me how many classes where there, and objects in each class?

4. What is Object qualification?

5. Tell me about a complicated object you have created?

6. What was the size of the database? Which server?

7. How many user were there?

8. What problems you have faced while creating an universe? tell me
an incident and how you went about solving it?

9. Were any experts called from BO while you were on the project?

10. What was the Database? Was it a data warehouse?

11. How many Tables was the universe built?

12. What is a loop, how do you resolve them?

13. What do prefer an Alias or a context? Why?

14. What is join? Explain different types of joins?

15. What are linked universes? Have you worked with them,
problems faced and solutions?

16. How many reports have you created? Explain a few?

17. What are alerters, filters, breaks, and master-detail?

18. What's the difference between master-detail and Breaks?

19. What's the difference between filters and conditions?

20. What are pre-defined conditions? Compare with report conditions? Justify?

21. What are the differences between a formula, variable and user objects?

22. Did you face any problems while creating reports? Name? Solutions?

23. How do you schedule the reports?

24. How were the reports scheduled and how to resolve unexecuted documents?

25. What is a micro cube? How many can a document have?

26. Have you worked with multiple data sources? If yes. How do you link them?

27. What are templates? Explain what you have created?

28. I have some multi data providers (excel, text, universe). I want only retrieve the data from excel only. How to write the query in query panel?

29. What is slice and dice? What is the use of slice and dice?

30. What is core dimension?

31. How do see the query performance in report?

32. I want to display the last refresh report date and time in the below of the report, how will you do that?

33. While running the query how much time it will taken, I want to see the time?

34. What is Report Bursting?

35. What is the use of alias and context? Which is the better for solving the loops? Why? Why we use alias and why we use context?

36. How to improve the query performance in to report level and designer level?

37. I have 3 tables A, B, C. I connected A to B and B to C. I want to report ABC, is there any loop problem will occur or not?

38. I have 4 tables A, B, C, D. I connected A to B, B to C, C to D and D to A. I want to report ABC, is there any loop problem will occur or not? What is the Problem?

39. How to interactive with Clients?

40. Can u tell me, what is the major problem you faced in your experience? How did you resolve the problem?

41. I have one problem? My Client to told resolve the problem with in 2 hours, but its taken by full day (8 hours). How will u convince the client?

42. How Many Classes and Objects you have in your Universe?

DIFF BTW CONDITION N FILTER:

A Condition feature that forces a query to retrieve only the data that meets specified criteria.condition is placed on a report query to show the specific data. To define a condition Name,Description and Where clause are required

A Filter enables you to view only necessary data in a report.i.e it allows you to restrict the no.of rows displayed in the report they effect only the data currently displayed in the block but not query results

Ex:select values for a variable in the report to apply a simple filter

RE: in a report can we hide an particular object ?
--------------------------------------------------------------------------------

yes we can show/hide a perticular object in a table by using the pivot tab of the format table dialog box

RE: what are the requirements for cube creation in bus...
--------------------------------------------------------------------------------

You should have a "Universe" with proper star or snowflak schema(Dimension and Fact) .Call this Universe in the "infoview" to create a web intelligent ananlysis(OLAP) report.

RE: Business objects is which type of the OLAP Tool?
--------------------------------------------------------------------------------

BO is ROLAP Tool

The functionality and feature sets are significantly different and so are the costs. Generally speaking, BI tools are categorized by a) their architecture (i.e., ROLAP, MOLAP, HOLAP, DOLAP, etc.) and b) their cost (i.e., high end or low end) which is usually related to the size of their feature set. For example, DOLAP solutions would include Cognos and Crystal, MOLAP solutions would include Essbase, SAS and Oracle Express, ROLAP solutions would include Business Objects, Informatica and Microstrategy and so on. Similarly, Cognos, Brio, Crystal and Microsoft OLAP are considered low-end solutions, while Business Objects, Microstrategy, Essbase and Informatica are considered high- end solutions.

RE: How does the hierarchy and scope of analysis help...
--------------------------------------------------------------------------------

Hierarchy is about the levelsorder of the objects in the classes. Eg. Time hierarchy in a time class will be Year, Quarter, Month, Week, Day, Hour, Minute, Second

By defining a scope of analysis during drilling you are specifying up to what level in the hirerachy do you want to drill. if you set scope of analysis as 2, the data will be drilled to Year, quarter. 3 will include month as well as so on.

Hope i am clear?

RE: what is the difference between break and section i...
--------------------------------------------------------------------------------

The major difference between these 2 are

It breaks up the data in a table or crosstab by grouping the data according to a selected value and it allows you to display all the data for each value of a dimension variable together mainly it displays SUBTOTALS. COLUMN BREAK's are used to avoid the repetetive value occurences

Section is obtained in the Master/detail reports which enable you to split large blocks of data into sections. This type of presentation allows you to minimize repeating values and to display subtotals.

October 25, 2006 09:41:42 #3
Goverdhan Reddy Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is the difference between break and section i...
--------------------------------------------------------------------------------

Here is the difference

Ex: Creating a Break and a Section

When you create a break on Year, the data remains as one block. The year values are repeated for each corresponding value of State and Sales Revenue.

When you create a section on Year, the data is no longer contained in one block, but divided into sections. One section for each value of Year. Each section is a separate block

RE: Can a universe be connected to different databases...
--------------------------------------------------------------------------------

yes, a universe can be connected to different database. However to do so, we have to link two universes which are on different database.

however if we consider, unlink universe(or only one universe), then it is not possible to have a universe that is connected to different database as in a universe we have only one connection at a time.

September 12, 2006 00:53:52 #2
sithu CRM Expert Member Since: March 2006 Total Comments: 31

--------------------------------------------------------------------------------
RE: Can a universe be connected to different databases...
--------------------------------------------------------------------------------

Yes,

You can do using multiple data providers

Cheers

Sithu, sithusithu@hotmail.com

September 22, 2006 09:33:24 #3
immas Member Since: September 2006 Total Comments: 2

--------------------------------------------------------------------------------
RE: Can a universe be connected to different databases...
--------------------------------------------------------------------------------

NO. A universe cannot connect to more than one database at the same time. But in Report we can use multiple data providers which internally two different universe and 2 different database.

October 03, 2006 06:55:01 #4
businessobjects Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: Can a universe be connected to different databases...
--------------------------------------------------------------------------------

NO a universe can not take the data from more that one database ,if ever we want data from another database we have to create another universe or use different data provider while report creation

QUESTIONl:

How do you Find the average of an object with out using the Average Function and by using only sum,average,max,min?

Use Sum() and Count() function like Sum() / Count() you will get your average value.

RE: Can you create Alerts in WEB Intelligence?
--------------------------------------------------------------------------------

In Version6 we can't create alerts in webi But it is available in XIR2

RE: What is diference between datamart and datawarehou...
--------------------------------------------------------------------------------

Data marts, simply defined, are smaller data warehouses that can function independently or can be interconnected to form a global integrated data warehouse

RE: what all will be exported to the repository, when ...
--------------------------------------------------------------------------------

when we export a universe first time,a unique identifier is allocated to the universe and this identifier is updated on the local version of the universe in the universe domain

If we export the universe to a diff,domain and now the universe has an identifier for diff-domain (EX:exporting a universe from a development domain to a production domain)

when a designer exports the universe to the Repository (universe domain) they must export all the related LOV files(which contains the data values associated with an object) to the document domain.

RE: how many tabs can be added in a report i.e. how ma...
--------------------------------------------------------------------------------

it depends on the hiearchy of the class.. but still w can define in slice and dice panel.. that is up to 2 times or 3 times... like that

RE: what is the maximum limit of the data providers in...
--------------------------------------------------------------------------------

There does not seem to be any limit however the documents say that you can have maximum of 15, but I have seen close to 50 datproviders in a report.

RE: is there any other repository domains rather than ...
--------------------------------------------------------------------------------

There are only three main Domains Security, Universe and document. You can have multiple Universe and Documents domains in a repository but only one Security domain.

RE: How do you check whether the data in the rep...
--------------------------------------------------------------------------------

We can copy the SQL Generated in the Query panel and run that SQL in the Database.

RE: What is a Data Cube ? What is its use ?
--------------------------------------------------------------------------------

Data cube will present in BO tool.

Data cube is used for storing the data values which we are using in the documents.

We can clear the data cube by using purge command.

Data provider is used to retrived the datas from data cube to documents.

August 28, 2006 17:05:52 #2
Aravind Sankaran Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: What is a Data Cube ? What is its use ?
--------------------------------------------------------------------------------

Data cube is the representation of data along every possible dimension included in the query.

September 27, 2006 14:24:38 #3
selva Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: What is a Data Cube ? What is its use ?
--------------------------------------------------------------------------------

data cubes are processing units composed of fact and dimensions.

RE: Are Data mart and DWH normalised or denormalised ?...
--------------------------------------------------------------------------------

Yes both can exist on the same tier because Datamart is a subset of data warehouse and it supports a particular region, business unit or business function.

The data in the Datamart and DWH is Denormalized and optimized for OLAP systems

RE: clearly explain the difference between union and g...
--------------------------------------------------------------------------------

hi

the difference between union and group is as follows:

take two tables t1 and t2.

in t1 we have columnss like a,b,c,d. and t2 has a,d,e,f.

so union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f

where as group performs on a indiviual column in a particular table.

August 12, 2006 08:16:20 #2
Venkatachalam Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
Not clear
--------------------------------------------------------------------------------

Clearly explain the group with one example

Venkat

August 21, 2006 11:30:50 #3
Reuben Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: clearly explain the difference between union and g...
--------------------------------------------------------------------------------

If a table has 2 columns Gender and Name

Gender Name

Male Tom

Male James

Male Harry

Female Jenny

Female Fern

Tom, James and Harry belong to Group Male.

Is that any clear?

September 02, 2006 01:57:19 #4
sumanbalaram Member Since: September 2006 Total Comments: 1

--------------------------------------------------------------------------------
RE: clearly explain the difference between union and g...
--------------------------------------------------------------------------------

union operation can be performed on basic cubes, remote cubes, ods objects, master data objects,infosets. i.e u can form union operation simultaneously on cubes, ods, master data objects, infosets. Multi provider does union operation.union operation can be performed on multi dimensional oblects.

But join operation is performed only on master data objects and Ods objects which are 2 dimensional. Infosets perform join operation.

with regards,

suman

RE: What is BO SDK?
--------------------------------------------------------------------------------

BO SDK is a software development kit. It is a part of Business objects Developer suite. It is used to customize or add more features to Business objects, designer and report viewer components.

Developer suite also contains Webintelligence SDK , which is used to customize Webintelligence.

RE: State the difference between Webi and Infoview
--------------------------------------------------------------------------------

In infoview you can create a webi documents i.e wid documents, you can open, schedule, save it as an excel or pdf or business objects document(.rep).

Webi is a part of Infoview

August 10, 2006 11:17:17 #2
Goverdhan Reddy Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: State the difference between Webi and Infoview
--------------------------------------------------------------------------------

Infoview is the portal to the BO's business intelligence solution and infoview also allows the third party documents and It contains document lists that give an instant overview of all the documents generated from corporate data storage and made availabe to users

August 10, 2006 11:19:12 #3
Goverdhan Reddy Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: State the difference between Webi and Infoview
--------------------------------------------------------------------------------

Web Intelligence is a leading web-based query,analysis and reporting tool and this provides a thin-client interface for powerful adhoc queries and simple analysis. It allows users to access, analyze and share corporate data over intranet,extranets for both RDBMS dbs and OLAP servers

August 10, 2006 11:22:41 #4
Goverdhan Reddy Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: State the difference between Webi and Infoview
--------------------------------------------------------------------------------

Difference between the Infoview and WI????

WebIntelligence is the 'thin-client' (or server version) of Business Objects Reporter. It is used to create report documents. It does not reside on the users computer, but on a server.

InfoView is what the user logs into, sees, and uses in their Internet Browser that allows the user to access and create Business Objects reports via the web without having to install the 'Full (or 'Thick') client Business Objects Reporter on their computer.

The user can only get to Webi through InfoView. It does not reside on the users computer, but on a server.

RE: what is the difference between detect alias and de...
--------------------------------------------------------------------------------

we should use Detect Aliases and Detect Contexts to formally identify and resolve loops.

i.e.if a loop contains only one lookup table then the loop can be resolved by detecting the alias

if a loop is having 2 or more fact tables(multiple fact tables) then the loop can be resolved by detecting context

RE: diffrence between ZABO and webi
--------------------------------------------------------------------------------

ZABO is zero administrator businessobjects , which will be installed on your local m/c when any full client report in opened/edited from infoview . For this you don't require any BO mainkey , key will be installed from BO server.Webi is also called as thin client , where -in you are create BO reports on web browser . Reports are only based on Universe .

August 03, 2006 03:01:21 #2
Senthil Raj Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: diffrence between ZABO and webi
--------------------------------------------------------------------------------

Both are user in 3-trier architecture.

ZABO-Zero Administration BusinessObject means we dont need to install BO to view the reports. while we open the reports through infoview the server installs the required components to your local machine. we dont need any bomain key etc.

Webi is a web based application in bo. we will create web based reports in webi(its a java based application). we can publish reports to personal & corporate by webi and can save as pdf file.

RE: what are all difference between business objects 6...
--------------------------------------------------------------------------------

I have found some differences b/w BO and XI and only the last is specific to XIR2

Difference between BO and XI

BO uses classic BO Architecture and XI uses crystal classic Architecture

BO uses 57 tables for BO repo and 8 tables for auditor where as XI uses 8 tables for CMS and 6 tables for auditor

BO has different security domains where as XI doesn’t has no different security domains

BO, all objects are stored in repository where as in XI Objects are physically stored in Input FRS and instances in output FRS

In BO after installing we have configure, create BO mainkey where as in XI it is install and start working

In BO classic key is an xml file and it has to be placed in relevant location where as in XI a key code is there

In BO if you want to save a report to repository you have to publish that report where as in XI if you click save as and select Enterprise

IN BO, BCA and supervision are entirely separate but in XI there are merged into CMC

IN XI there is no separate auditor is there but there is an auditor database where we can create tables based on that

BO has it’s own reporting toos where as XI uses crystal reports as it’s reporting tool

BO is user centric – means rights are assigned to user where as XI is object centric – means rights are assigned on objects level not user level

BO – all reports are stored in categories, in XI infoview there is folder and categories but all main storage is in folders

In XI R1 there was no concept of full client but that concept is introduced in XI R2

QUES:

Kindly numberWhat are the steps to be taken to schedule the report?

You can schedule any report using Business Objects (reporter) .1) Open report in BO2) Select option " File->Send To- BCA"3) Select the BCA name to which report has to be scheduled4) Set other options for report scheduling like time , any macro , user etc.

RE: What are the steps to do to use Alerts in BO?
--------------------------------------------------------------------------------

alerts are used to alert some part of the data if any change occurs .

select the part of the data in the report where u want to keep alerts n just click on alerts in the tool bar which is present in the third line from menu bar besides rank

then a window pops up n we ca n give some condition where in if it crosses that an alert is sent.

11th feb,21 april

RE: What is aggregate awareness and how can we use it?...
--------------------------------------------------------------------------------

aggregate awareness function is used to aggregate the values present in the classes in decending order.

for instance we have year,quarter,month,week tables

then we sum the year,sum(quarter),sum(month),sum(week) in decending order respectively.

we also select the compatable as well as incompatible objects through aggregate navigation so that it improves the performance of the system in generating the report.

September 27, 2006 09:26:12 #2
OM PRAKASH BANG Microsoft Expert Member Since: March 2006 Total Comments: 45

--------------------------------------------------------------------------------
RE: What is aggregate awareness and how can we use it?...
--------------------------------------------------------------------------------

You can use features in Designer to allow you to define the Select statement for an object to run a query against aggregate tables in the database instead of the base tables. You can set conditions so that a query will be run against aggregate tables when it optimizes the query, and if not, then the query will be run against the base tables. This ability of an object to use aggregate tables to optimize a query is called aggregate awareness.

RE: what if a cartesian product pop up block appears w...
--------------------------------------------------------------------------------

cartesian product is getting incorrect results.

for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.

ex:-

we have customer,orders,loans classes

orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in order to solve fan trap we create alias table.

RE: How do we test the reports in the business objects...
--------------------------------------------------------------------------------

In the central mangement consol one can test the report.

RE: What is meant by Object Stores?
--------------------------------------------------------------------------------

object store is nothing but the container of object which is created after rpt file run once.

QUESTION:Please explain about Alerts in Bo's, Under what situation we need to use alerts

hello friends,here alert means to highlighted data in a particular report.in every report we can apply alerts situtation like, sales revenue per city wise.here city field we can apply alert,condition like sales revenue >=50,000

QUESTION:what is drill filter and it's usage ? How many types of filters are there ?

RE: what is drill filter and it's usage ? How many typ...
--------------------------------------------------------------------------------

I dont think there is any number of type in drill through filter, drill through filter is used to fech the particular data from the report or other report by click browse while in the drill through process.

July 20, 2006 11:12:14 #2
MuthuKumar Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is drill filter and it's usage ? How many typ...
--------------------------------------------------------------------------------

Three types of drill is in BO.1.drill up,2.drill down,3.drill thro'.

drill up means second->minutes->hour->->day

drill down means region->country->state->district

drill thro'--wht ever u want that element

October 03, 2006 07:43:15 #3
businessobjects Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is drill filter and it's usage ? How many typ...
--------------------------------------------------------------------------------

drill filters acts as query conditions when you bring new data from from database

we can not say there are different types of drill filters,because we apply filters through scope os analysis and set the apply drill filters option by

tools >options>drill tab

there are different drill modes like drill up,drill down,drill through

RE: what is drill filter and it's usage ? How many typ...
--------------------------------------------------------------------------------

I dont think there is any number of type in drill through filter, drill through filter is used to fech the particular data from the report or other report by click browse while in the drill through process.

July 20, 2006 11:12:14 #2
MuthuKumar Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is drill filter and it's usage ? How many typ...
--------------------------------------------------------------------------------

Three types of drill is in BO.1.drill up,2.drill down,3.drill thro'.

drill up means second->minutes->hour->->day

drill down means region->country->state->district

drill thro'--wht ever u want that element

RE: What is report template in B.O?
--------------------------------------------------------------------------------

Report Template is a specimen for your future reports.

You create a report from scratch, say make it Master-Detail Report with charts, put your company logo, add some default colors(something like same colors your company uses for its documents, webpages etc.) & then save it as BO Report Template file.

Next time when you are creating new reports, & select use Templates option, your report saved as template will be listed in the box. If you select it, your new report will automatically use all color formats, & table-chart structures, logo....whatever you used in your template report file.

Advantage : 1 time devaelopment of display & structure format, for multiple reports use. i.e. Time Saving. No need of formatting for all standard reports.

Cheers,

Patrick.

RE: How to schedule the report in B.O?
--------------------------------------------------------------------------------

we can schedule the reports through broadcast agent.

RE: how many universes can be created in a project...
--------------------------------------------------------------------------------

Hi,

Â In a project you can create multiple universe. For multiple universe usage linked universe is a ideal concept.

Regards

Sandeep

RE: How to generate the report from excel sheet?
--------------------------------------------------------------------------------

start BO,

Select "Others" on Data Providers wizard page,

from drop down menu, select "ersonal data files",

specify file location & check the box "First Row contains Column names" this will help you in creating Objects.

click Ok.

Start building your reports.......

Cheers,

Patrick.

RE: what is a derived table in data warehousing?
--------------------------------------------------------------------------------

hi

it is similar to views,it is mainly used to restrict the datas

RE: how to execute the plsql procedure from the report...
--------------------------------------------------------------------------------

we can select either tables or procedures or views as our data to generate our reports.In the designer in bo's we can select tab "insert" n select the particular data source for generating the report through mouse click.

RE: What is a fantrap in Business Objects?
--------------------------------------------------------------------------------

Actually FAN TRAP is a problem that occurs in Universe Level. Loop occurs while we design the universe.

Two Types of Loop Problem:

1) FANTRAP PROBLEM solved by ALIAS METHOD:

Definition: Two One-to-many table link eachother is in turn linked another one-to-many table.

2) CHASM TRAP PROBLEM solved by CONTEXT METHOD:

Definition: Two Many-to-one table converges on one single lookup table.

Loop can be detected while INTEGRITY CHECK is done. An option is there as "Check for LOOPS" available. By "Detect Loop" we can choose what to be applied for solving the loop.

RE: How Do U Create Report in BO,If given Fixed length...
--------------------------------------------------------------------------------

To create a report using notpad (.txt files) :

1.open BusinessObjects --> new report

2. select data provider as Others instead of universe,

from "Others" drop down list, select "Personal Data Files",
File selection box appears, specify the location of your text file,
if you have saperated data by tabs in text file select "Tabulation" if by comma then "Comma Saperated" (I dont remember the exact caption for this option) & if space saperated then select "Charectors"(I dont remember the exact caption for this option)
if you have specified column names in your text file, check the box "First Row contains Column names"
Run the report.

hope this helps you,

cheers,

Pat.

RE: what is Nested prompt and how to create this promp...
--------------------------------------------------------------------------------

Nested prompts are called "Cascading Prompts" in BusinessObjects environment. try searching for this keyword.

to create cascading prompts, you need to edit the properties of an object & impose another prompt as a condition.

RE: what is thumbnail?
--------------------------------------------------------------------------------

BusinessObjects Enterprise lets you preview a report using thumbnails. You can request the server to take a snapshot of the first page of the report and return it to the browser as an image file. This image can then be displayed as part of the Report Details page.

To retrieve a thumbnail, a separate page needs to be created because the code that writes an image to the screen erases any text that may have previously been there.

RE: Can someone please give some information on REPORT...
--------------------------------------------------------------------------------

If some part of the data in your report is sensative, you can't risk sending the whole report to everybody, even to those who need to see the least sensative part of report !

Solution is Report Bursting.

You can send reports to BCA for scheduled processing & distribution to users based on THEIR profiles (profile = user rights) & not based on your profile !

BO 5 & WebI 2.5 procedure to do this :

Open the document, click "Send to BroadCast Agent" on Doc Exchange toolbar.
In Actions tab select "Refresh with the Profile of Each Recipient"
In the Distributions tab select "Distribute via the Business Objects Repository. (only option to enable you for Report Bursting)
click To, select recipients,
Schedule it & OK.
In WebI 2.5...........

in Refresh options Select Scheduled Refresh & click send

on Scheduling Options, Set "Refresh According to the profile of each recipient" to Yes & OK.

RE: can you please clarify the difference between comp...
--------------------------------------------------------------------------------

When you are defining Aggregate tables in Universe design, you need to create hirarchies for aggregated objects, for that you need to make the relative objects incompatible (the objects which are of lower level of aggregation -- not of hirarchy).

If you have Year,Quarter,Month,Day as a hirarchy, while aggregation, you need to define as follows -

Year - Quarter,Month,Day Compatibles

Quarter - Month, Day Compatibles, Year Non-compatible

Month - Day Compatible, Year,Quarter Non-compatible

Cheers,

Patrick.

RE: can someone please let me know the things we can d...
--------------------------------------------------------------------------------

Hi,

I think

1) we can create\edit Universe in the full client but not in WebI

2)WebI has comparatively less functions to use than in Full client

3) In Full Client we can write macros\addins but i am not sure whether we can do the same in WebI or not.

Please revert back if these are wrong.

Thanks & Regards,

Ram

May 29, 2006 01:02:14 #2
NRRaman ERP Expert Member Since: April 2006 Total Comments: 2

--------------------------------------------------------------------------------
RE: can someone please let me know the things we can d...
--------------------------------------------------------------------------------

Hi,

In addition to those in my previous mail,

1) We can edit SQL in Full client but not in WebI

2)we can apply Rank in Full client but not in Webi

3) Better formatting facilities in Full client wrt Webi

Thanks & Regards,

Raman

June 23, 2006 07:23:32 #3
Miya Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: can someone please let me know the things we can d...
--------------------------------------------------------------------------------

Hi,

FYI.

Difference between Thin and Fat installations

Feature
BO
WebI

Data Access Via,

Stored Procedures, Free hand SQL, Personal Data files (.txt, .xls, .wk, .prn, .asc)
Yes
No

Ability to access Multiple source in a single report
Yes
No

Can access other OLAP server (Microsoft OLAP, DB2 OLAP and Oracle Express)
Yes
No

Ability to use report templates
Yes
No

Ability to create more than one report in a single Business Objects document
Yes
No

Multiple views of the same data in a single report (pie chart, tabular, cross tab, etc)
Yes
No

Ability to analyze Business Objects report data with Data mining product “Business Miner”
Yes
No

Ability to create “Variables” in document level.
Yes
No

Ability to send Business Objects report via Microsoft mail
Yes
No

Ability to compare an object with

Another object, Sub Query, Calculation

in condition (“Where” Clause)
Yes
No

Ability to display only the top and bottom values by a another variable
Yes (By Ranking)
No

Ability to build two or more queries in the Query Panel and to combine these queries by using an operator (UNION, INTERSECT, or MINUS)
Yes
No

Ability to use BusinessObjects own build-in functions in report.
Yes
No

Dense rank
--------------------------------------------------------------------------------

The DENSE_RANK function computes the rank of a row in an ordered group of rows. The ranks are consecutive integers beginning with 1. The largest rank value is the number of unique values returned by the query. Rank values are not skipped in the event of ties. Rows with equal values for the ranking criteria receive the same rank.

The DENSE_RANK function does not skip numbers and will assign the same number to those rows with the same value. Hence, after the result set is built in the inline view, we can simply select all of the rows with a dense rank of three or less, this gives us everyone who makes the top three salaries by department number.

ex:

Give me the set of sales people who make the top 3 salaries - that is, find the set of distinct salary amounts, sort them, take the largest three, and give me everyone who makes one of those values.

SELECT * FROM (
SELECT deptno, ename, sal,
DENSE_RANK()
OVER (
PARTITION BY deptno ORDER BY sal desc
) TopN FROM emp
)
WHERE TopN <= 3
ORDER BY deptno, sal DESC
/

DEPTNO ENAME SAL TOPN
---------- ---------- ---------- ----------
10 KING 5000 1
CLARK 2450 2
MILLER 1300 3

20 SCOTT 3000 1 <--- ! (in case of rank JONES will have 3 and dense rank will have 2)
FORD 3000 1 <--- !
JONES 2975 2
ADAMS 1100 3

30 BLAKE 2850 1
ALLEN 1600 2
30 TURNER 1500 3

RE: How to break a Date field into Year, month, week,d...
--------------------------------------------------------------------------------

Create objects in your universe with date functions.

Let's say your DB is Oracle. In your "Select" statement of new object called year, try

to_char(INVOICE_DATE, 'YYYY') similarly for month create object called month & repeat process, simply replace'YYYY' with 'MM' of 'MMM' in the select statement. & so on.

RE: How we drill up week to Month?
--------------------------------------------------------------------------------

In data Warehouse when u change + symbol to - , u would c all the aggregation level in that + this is called rolling down.

So if u again click over that - it would again compressed back to +. This is call drill up.

your Aggregation levels woudl b like

Year>Month>Week>Day>Hour>Minutes>Seconds.

So by changing the symbol from - to + at month aggregation level u can drill up.

RE: what is the diferrence between slice and dice and ...
--------------------------------------------------------------------------------

cross tab report is like at the intersection of 2 dimensions measure is displayed.like if we have two dimensions year and product and a measure revenu,revenue is displayed at the intersection of year and product.

March 25, 2006 04:10:55 #3
sithu CRM Expert Member Since: March 2006 Total Comments: 31

--------------------------------------------------------------------------------
RE: what is the diferrence between slice and dice and ...
--------------------------------------------------------------------------------

A standard report can be sliced and diced but not the crosstabed oneCheers,Sithu

RE: what is the diferrence between slice and dice & dr...
--------------------------------------------------------------------------------

Slice and dice is you are going to analyze the data in different angle, but drill through is like using a single value you are going to grain the data.Cheers,Sithu

April 26, 2006 05:28:32 #2
Ramu Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is the diferrence between slice and dice & dr...
--------------------------------------------------------------------------------

slice and dice means change the postion of the data like move the data from rows to columns

drill mode means allow u to analyze the data in different angles and different levels of details..

in drill mode different types of analysis's are there like drill up, drill down, drill accross, drill through.

drill through means option to select any step or level directly from the current level..

these are the main difference between slice and dice and drill through

with cheers

Ramu

RE: what is the difference between condition & filter....
--------------------------------------------------------------------------------

Conditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level)Cheers,Sithu

RE: my query takes 30 min to refresh ...there is any p...
--------------------------------------------------------------------------------

- make sure to have the right context

- apply right indexes on the tables

RE: what is the diferrence beteeen tabular report& cro...
--------------------------------------------------------------------------------

Tabular reports is a 2D format and Cross tab reports is a 3D format. Most of the operational/formated reports will be created in tabular form and most of the analytical reports are created in the cross tab report form (Product VS Year VS Sales amount)

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.

RE: How to filter repeatative values in the report to ...
--------------------------------------------------------------------------------

In the Query pannel ..we have tab "Options"..

click there to get "eliminate dupicate"..enable this options..

its may help u..

February 15, 2006 09:41:56 #2
rahul Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: How to filter repeatative values in the report to ...
--------------------------------------------------------------------------------

Using the eliminate duplicates option is one way.

In a clightly different scenario, duplicates could come up due to the design structure of the report. e.g.

In some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION ERROR). To avoid such situation, one can define a variable which would e the max of the original field required. That ways the same value is fetched and also only one value is returned.

March 18, 2006 12:59:00 #3
Omkar Paranjpe Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: How to filter repeatative values in the report to ...
--------------------------------------------------------------------------------

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.

RE: How achieve the many to many relation ship in Busi...
--------------------------------------------------------------------------------

m to m relation ship

m to 1 1 to m

this way you can join

mahudes

April 03, 2006 12:46:26 #2
Dr. Suresh Rajappa PhD PMP MCP Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: How achieve the many to many relation ship in Busi...
--------------------------------------------------------------------------------

if you have two tables with many to many relation ship, take the keys of those tables and form a 1-1 relationship table. then you can connect both the existing tables to the newly formed table using the key.

August 10, 2006 02:29:39 #3
ALuthra Member Since: August 2006 Total Comments: 1

--------------------------------------------------------------------------------
RE: How achieve the many to many relation ship in Busi...
--------------------------------------------------------------------------------

Create an intermediate table with 2 keys .. i.e., the primary keys of both tables. Join each table to its primary key in the intermediate table.

RE: How many ways we test the universe & Report?
--------------------------------------------------------------------------------

By doing integrity check we can test universe & By coping report query and run in backend(oracle,sql server...) we can test the data by comparing both.

RE: what is the multi value error ?Is there any ...
--------------------------------------------------------------------------------

Yes,#MULTIVALUE error is there in BO.It's common when u r trying to use multi valued multiple objects in section.

Go through error documentation for further details...

February 07, 2006 08:15:39 #2
jay Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is the multi value error ?Is there any ...
--------------------------------------------------------------------------------

Hi,

you will get the Multi Value Error when you are trying to retrivr mutiple values into the cell.

Ex: When u r tying to Insert cell into report and trying to assign a column to it which will have multiple values in it. (In A single cell you can’t show multiple values)

RE: what is difference between custom hierarchy and re...
--------------------------------------------------------------------------------

By default one class having one hierarchy ie called report hierarchy.Custom hierarchy we can create in designer according our req.

Question:I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

The Prompts will appear in the alphabetical order.

To make them appear in the order of our requirement, need to prefix a numerical with the prompt

RE: What are the user requirements in a universe?
--------------------------------------------------------------------------------

Database connections, key column, joins and check for loopif you need mesures, metrics, cheers,www.sithu.s5.com

RE: When to use local filter and when to use global Fi...
--------------------------------------------------------------------------------

think this should be in the Reporter Forum but, a local filter would apply to just a single block (table, cross tab or chart) within your report.

a global filter would apply to all blocks in your report, so if you had many tables the filter would apply to all of them

November 25, 2005 08:54:42 #2
Eswar Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: When to use local filter and when to use global Fi...
--------------------------------------------------------------------------------

Local Filter is to single report to which it is create, but a global filter is to all the reports which consists of that column

RE: give the notes and functionalities of cascading pr...
--------------------------------------------------------------------------------

cascading prompts :cascading prompts means one prompt depends on another prompt.. if suppose u want select one district.its depends on state.then it depends on country..so one prompt depends on another..its work as first come the prompt of district when ever we going select value.automatically coming the state prompt..then country prompt..when ever we select the contry it goes to state then district..

@script: its belongs to vba application

January 30, 2006 00:44:52 #2
Sithu Database Expert Member Since: December 2005 Total Comments: 162

--------------------------------------------------------------------------------
RE: give the notes and functionalities of cascading pr...
--------------------------------------------------------------------------------

Syntax

@Prompt ('message', ['type'], [lov], [MONO|MULTI], [FREE|CONSTRAINED])

where
message is the text of a message within single quotes.
type can be one of the following: 'A' for alphanumeric, 'N' for number, or 'D' for date.
lov can be either a list of values enclosed in brackets (each value must be within single quotes and separated by commas) or the name of a class and object separated by a backslash and within single quotes.
MONO means that the prompt accepts only one value. MULTI means that the prompt can accept several values.
FREE refers to free input as opposed to CONSTRAINED, which means that the end user must choose a value suggested by the prompt.

Description

Is used to create an interactive object. In the Query Panel, this type of object causes a message to appear. This message prompts the end user to enter a specific value.
Note

The last four arguments are optional; however, if you omit an argument you must still enter the commas as separators.
Example

In Where Clause:
City.city IN @Prompt ('Choose City', 'A', {'Chicago', 'Boston', 'New York'}, MULTI, FREE)
In the Query Panel, the object prompts the end user to choose a city.

RE: what is a bo repository
--------------------------------------------------------------------------------

ITS A SEMANTIC LAYER WHICH STORES THE BO USERS N THEIR PRIVILEGES

November 12, 2005 13:15:28 #2
shivanand Database Expert Member Since: November 2005 Total Comments: 1

--------------------------------------------------------------------------------
RE: what is a bo repository
--------------------------------------------------------------------------------

Repository means set of database tables, Business object store security information e.g user, group, access permission, user type etc. , universe information e.g. objects, classes, table name, column name, relation ship etc.and document information.

November 24, 2005 09:48:57 #3
vajravelu Database Expert Member Since: November 2005 Total Comments: 1

--------------------------------------------------------------------------------
RE: what is a bo repository
--------------------------------------------------------------------------------

repository is data accounts which contains three domains in each one type.you can create the repository any where .the security domain has the user security info and other domains address. you can have more than one repository but you can use which one u specifying on the time of login. the address info of the security domains is strored in the .key file if WebI its in the Bomain.keyfor more refre the cindi howson book and visit her web www. Askcindi.com

November 30, 2005 01:37:32 #4
malik Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is a bo repository
--------------------------------------------------------------------------------

BO repository is an set of db tables which holds the metadata information.This bo repository is divided in to 3 domains Security,universe,document domain.This metadata holds all the information related to users groups their priveleges...........except the "supervisor" thsi is the super user of bo rep.the supervisor info is stored BOMain.key which is stored in default thome dir of bo.

December 08, 2005 04:37:31 #5
Melwyn Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is a bo repository
--------------------------------------------------------------------------------

BO Repository is a set of related data structures of BO stored in a database. It contains tables of Security, Documents and Universe Domains

January 10, 2006 06:45:24 #6
Sithu Database Expert Member Since: December 2005 Total Comments: 162

--------------------------------------------------------------------------------
RE: what is a bo repository
--------------------------------------------------------------------------------

Generally Repository is the Metadata

BO 5.0 Repository create/maintain 50 tables, they are distributed as follows

25 tables for Security domain

24 Table for Universe domain

1 Table for Document Domain

Cheers,

Sithu

March 31, 2006 05:01:19 #7
mahudeswaran Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is a bo repository
--------------------------------------------------------------------------------

in 6.5.1 repository

25 tables in sec.domin

1 table in doc domin

31 tables in uni domin

it is a matadata

October 25, 2006 17:20:47 #8
John Mike Member Since: Visitor Total Comments: N/A

--------------------------------------------------------------------------------
RE: what is a bo repository
--------------------------------------------------------------------------------

Can some one provide the BO XI rel 2 repository Domains(Number of tables for each domain)..

A context is simply a list of joins denoting a path between tables.

Contexts are set to identify alternative routes in the universe structure.

BusinessObjects detects a context for each alternative route.

Contexts identify tables which are incompatible within the same SELECT statement - because the wrong results will be produced.

Vishnu Kiran

Thursday, October 11, 2012

Excel short cut keys

Logging error in Biz talk Orchestration

Thursday, October 4, 2012

Business Object Interview questions

Ribbon Sharepoint Urls

About Me

Blog Archive