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

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

Explain what would you consider as your biggest achievement and why?

661


Difference between zabo and webi?

755


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1931


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

677


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

709






What is thumbnail?

666


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1630


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

1528


Explain what are the measure objects?

644


Explain when we use aggregate awareness function in designer?

673


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

716


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3100


What is difference between custom hierarchy and report based hierarchy?

643


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1657


Explain is data mart?

680