1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

How to particiapte the columns availabe in the Derived
tables in the Reporting window? How it's done?

Question Posted / guest


How to particiapte the columns availabe in the Derived tables in the Reporting window? How it'..

Answer / shamanth

We derive a table at Universe level for a particular
requirement.

Derived tables acts as normal tables in UNV designing, we
can join these tables with other tables and include the
columns into query.
Also we can perform diff. operations as we do for other
tables.

Tools -> List of Derived Tables -> We can view/modify the
existing tables
Insert -> Derived tables

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Business Objects Interview Questions

I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,

What are the major problems will occur while migrating to the one version to another version?

2 Answers   CTS,

WHAT IS CARDINALITIES OF JOIN?

3 Answers  

Explain the SQL Queries activated to data base from Data provider in BO ?

1 Answers   Polaris,

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers   Honeywell,




What is difference between custom hierarchy and report based hierarchy?

0 Answers  

How to get top 5 rows of a selected column?

3 Answers   Patni,

what is the difference between input file repository server and output file repository server ?

2 Answers   CTS,

What is the report extension in webi and deski

2 Answers  

Is it possible to develop reports without Universe access?

7 Answers   IBM,

When we are going for Shortcut join and why.

1 Answers   Cap Gemini,

what is profile and packages in BOXI??

1 Answers  

For more Business Objects Interview Questions Click Here
Categories