1) How to get multi values in a single prompt?
2) How to get ALL in @prompt?
3) Select 1 from fact table? What will be the result?
4) I have created 1 universe say A and generated 100 reports
on the universe? Later i had renamed the Universe as A1 and
added some objects? Now how i will get the newly added
objects in old reports?

Answer Posted / gowthami

1. Following is the syntax for the function.
@Prompt('message','type',[lov],Mono|Multi,free|constrained|primary_key,persistent|not_persistent,[default_values])
Use Multi in the above syntax

2. @Select(Class NameObject Name) = @Prompt('Select State','A','Class NameObject Name',mono,free)
or 'ALL' = @Prompt('Select State','A','Class NameObject Name',mono,free)
3.
4. When the universe or reports are saved, unique id will be generated. If you rename the universe name that ID will remain the same. The old reports are pointing to the same universe only by linking to the unique id.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the steps to do to use alerts in bo?

608


what is document design in boxi,have u participate in that

1659


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2400


How we drill up week to month?

615


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)?

571






Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1904


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

1825


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

1395


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

596


how to prepare the documentation in business objects and where to get the requirement?

1778


Explain is data mart?

586


Did you face any problems while creating reports? Name? Solutions?

3256


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1689


Explain what is the difference between business requirement document and use case document.

577


what is the difference b/w the refresh and buffered data?

1759