Is it possible to create a Universe using flat file? If Yes, How?

vadivelmothi

 Profile Answers by vadivelmothi Questions by vadivelmothi

• Mar 10th, 2011

Yes we can create the univese by using flat files, for creating the universe we need DSN (Data source name) that is using ODBC connectivity u can create the DSN,Create a DSN for the flat files and try...

RishiBO

 Profile Answers by RishiBO Questions by RishiBO

• Jan 18th, 2010

No we can'tUniverse and flat file are data providers for generating the reports.

Answer Question  Select Best Answer

How will you ensure that the universe designed is optimum?

Rajnish_kaushal

 Profile Answers by Rajnish_kaushal Questions by Rajnish_kaushal

• Apr 13th, 2009

Best way to make sure Universe Design is optimum is by following the best practices. couple of things which we can look into for optimisation1. Connection parameters are set as per the underlying datb...

prashantpurohit2000

 Profile Answers by prashantpurohit2000 Questions by prashantpurohit2000

• Mar 4th, 2009

Some of the precautions you should always keep in mind: • Do not use automatic universe creation tool, design your universe piece by piece and insert one table at a time also the joins and cardin...

Answer Question  Select Best Answer

How to give the SQL button option access from Business objects 6.5?

RishiBO

 Profile Answers by RishiBO Questions by 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

 Profile Answers by RishiBO Questions by 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 

Answer Question  Select Best Answer

How to create hyperlinks in Infoview Charts?

Milind

• Mar 19th, 2015

First?make?sure?that?column?appears?in?other?report?so?that?you?can?link?them?Open?infoview..select?report..right?click..modify..select?column?for?hyperlink?thats?it ..

Omar Chowdhury

• Jul 18th, 2012

There is Alerter option in Webi/Webi rich Client. By using this option u can highlight as much as you want. And there is also sub-alerter under Alerter.

Answer Question  Select Best Answer

How to create hierarchies and conditional objects in the designer?

RishiBO

 Profile Answers by RishiBO Questions by 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.

Sivakami_Plr

 Profile Answers by Sivakami_Plr Questions by Sivakami_Plr

• Oct 29th, 2009

Both can be created in designer. Just like creating objects

Answer Question  Select Best Answer

What are the general differences between the desktop intelligence and web intelligence

vamsi.reddy21

 Profile Answers by vamsi.reddy21 Questions by 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

 Profile Answers by Sowmya Viswanath Questions by 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...

Answer Question  Select Best Answer

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

 Profile Answers by boe_123 Questions by 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

 Profile Answers by smghurde2 Questions by smghurde2

• Sep 10th, 2009

A coulmn can be entered in crosstab report, however it will insert seperate column for each value of columns.

Answer Question  Select Best Answer

What will happen if you use objects from two different DataProviders from two different universes?

54446

 Profile Answers by 54446 Questions by 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...

rav123

 Profile Answers by rav123 Questions by rav123

• Aug 6th, 2009

Partial results would be displayed in the report because of Synchronization.

Answer Question  Select Best Answer

What could be the possible problem if the report keeps on running without responding even before prompt comes up?

sreenu435

 Profile Answers by sreenu435 Questions by sreenu435

• Mar 10th, 2011

If it is before prompts then problem with paramenters passing or server problem, not db problem. After prompts report tries to connect to db so it could be problem in passing paramenters.

prakharrajsingh

 Profile Answers by prakharrajsingh Questions by prakharrajsingh

• Sep 19th, 2009

If all CR (with or without prompt) behave in same way then something is wrong with your CRPE.Otherwise, there is some problem with prompts.Try changing the viewer for CR and it may run fine.Cheers.

Answer Question  Select Best Answer

How to add a description to the list of values?

Abhishek

• Jul 21st, 2015

A LOV is a file which contains list of values of a particular objects.

anil

• Sep 3rd, 2014

A list of the distinct values from the column or columns to which the object refers

Answer Question  Select Best Answer

Full form of BOBJ. Explain the usage of BOBJ

sivarenu01

 Profile Answers by sivarenu01 Questions by sivarenu01

• Sep 6th, 2011

B - business obj - object

satish kumar bodige

• Jul 23rd, 2011

BOBJ means business objects.......

Answer Question  Select Best Answer

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 30th, 2012

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...

jee

• Sep 30th, 2011

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...

Answer Question  Select Best Answer

in BO 6.5 , how to develop the report 1 universe is x repository and 2 universe iis from y repository, i want to develop a reports of combined of both universities

kiran(9035165714)

• Feb 27th, 2012

You can combine two universes by using link parameter, but at that time two is same database,suppose one is local repository another one is server repositories you combine to both universe to server repository or local repository

vinod

• Dec 30th, 2011

We cannot link universes which are built on top of different data sources, but we can built reports from them in webi through multiple universe option. Another way is by creating schema using DATA FE...

Answer Question  Select Best Answer

kiran

• Feb 29th, 2012

Dashboard is contain summarized data and its can view good quality of presentation.

vparit

 Profile Answers by vparit Questions by vparit

• Feb 13th, 2012

Dashboards give dynamic interactivity and easier way of representation and summarized level of values

Answer Question  Select Best Answer

kiran

• Feb 29th, 2012

In BOxi3.1 we have freestanding cells ,in that current date function one cell is there u can drag and drop into report header it will display current date,or u can create a variable like current date(object)

Preeti Rai

• Jan 28th, 2012

By Using CurrentDate function

Answer Question  Select Best Answer

If we have two data sources and we have to take two tables form each source and generate one report.

How to do?.

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 30th, 2012

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...

VP

• Apr 2nd, 2012

Two data source which has two table has to be merged with a common dimension,then build the report

Answer Question  Select Best Answer

I have to use universes with different database connections in the same application knowing that only one BO Connection can be provided in BO Sync.

Is It Possible?

Please reply asap.

kishoere

• Jul 31st, 2012

Linking the data base in the universe levels

anonymous

• Apr 28th, 2012

according to your question you want data synchronization from two different database..(it means they r not relational data so cant get synchronized anyway)...now if u have one database(relational) b...

Answer Question  Select Best Answer

vishwanath_bhambure

 Profile Answers by vishwanath_bhambure Questions by vishwanath_bhambure

• Oct 18th, 2013

Using Data synchronization.

We have to merge the dimension from both the data providers in the report to generate the report using the two different data providers.

Option 2 :
Make DBLINK between Database A & B and access both the database tables by pointing application to one of the database.

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Oct 7th, 2013

Well, If you are using BO4 then you would need to make to Relational Conn.(RC) point out to required Databases and than you will able to make it Datafoundation (DF) based on two source databases.
Hope it helps.

Answer Question  Select Best Answer

What are the Roles and Responsibilities of SAP BO Consultant

Brahmareddy

• Mar 16th, 2016

The Roles are Purely Defends Upon Types of Projects.... -----If it is Development Project---- 1.Requirements gathering 2.Clarification interactions 3.Technical specification documents 4.Development(Re...

Jitin

• Jan 29th, 2016

To me, a BO Consultant is a person not only with good technical expertise on the subject but also has knowledge on the domain(retail, banking, pharma etc), and ofcourse has analytical skills and skill...

Answer Question  Select Best Answer

Hi,

I have to develop a Webi report (3.1) in which I need to calculate sales for 6 weeks like this

Date Range Sales

Dec 28,2015 - Jan 3,2016 23,000
Jan 4 ,2016 - Jan 10, 2016 16,000
Jan 11,2016 - Jan 17,2016 7,000
Jan 18,2016 - Jan 24,2016 ...

Sanjay Mohan

• Jun 15th, 2017

1. Could you please share me the Quantifiable measure used within?

@Vara

• Feb 2nd, 2017

If you have access to write Custom Query in the Report, it will be easy. I am not sure about report level.

Answer Question  Select Best Answer