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
Can anybody tell me what are the tuning problems?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Is there any other repository domains rather than universe, security, document?
Explain how to schedule the report in b.o?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What is the difference between slice and dice and cross tab report?
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
What is a bo repository?
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?
What is thumbnail?
what is document design in boxi,have u participate in that
What is the difference between absolute and relative div positioning?
How many universes can be created in a project?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?