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 / 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 |
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
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?
any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....
What is the size of data base?
Explain which versions are used in the bo dashboard work?
What is the strategies ? what is the need of the strategies?
how to create a derived table in designer? i need steps regarding derived table
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
i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?
What is global filters and local filters
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...