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 / shamanth

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2064

Explain how to execute the plsql procedure from the report by clicking with mouse?

681

How can you first report in Business Objects by using broadcast agent?

2700

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1738

What is the difference between absolute and relative div positioning?

679




IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9625

Explain is there any default username & pwd for bo designer & supervisor?

686

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1649

What is the difference between the public object&schema object?

677

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1531

What is difference between webi and infoview?

728

How to execute the plsql procedure from the report by clicking with mouse?

705

explain in detail about type 3?

707

What is aggregate table and aggregate fact table ... Any examples of both?

696

Give some information on report bursting?

648