Answer Posted / yandapalli.prasad
A PRAGMA statement appears in a PL/SQL block. It is not an
executable statement, but it provides instructions to the
compiler.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
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 ?
What Is Snow Flake Schema?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Give some information on report bursting?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
what is the difference b/w the refresh and buffered data?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain difference between zabo and webi?
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 my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
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?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
how to create metric universe ?