if u drag the variable, automatically sql query will be added.

how do we apply sql query on selected variables?

Question Posted / narsi

3 Answers
6981 Views
I also Faced
E-Mail Answers

Answer Posted / narsi

if u drag the variable, automatically sql query will be
added.

or
if u select new variable, one window will appear. in this
window u select the qualification(dia or detail or measure)
in defination window. go for formula tab, window will
appear here write a formula by using objects & operators.
if u have any errors or not plz check once parse condition.
Click apply > click ok.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about a tricky situation for which you found a very simple solution?

992

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

1868

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

1998

Explain how many universes can be created in a project?

1053

What is difference between custom hierarchy and report based hierarchy?

1008

Differences between business objects and web intelligence reports?

1206

What is the difference between slice and dice and cross tab report?

1038

How to schedule the report in b.o?

1003

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

3048

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1013

What three things do you consider to be the most important factors for a manager?

1075

What are the data types present in bo? What happens if we implement view in the designer and report?

1024

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1044

Explain what are the steps to be taken to schedule the report?

1099

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2266