Ravi

• Dec 8th, 2005

A PRAGMA statement appears in a PL/SQL block. It is not an executable statement, but it provides instructions to the compiler.

kiranvileti

• Nov 19th, 2005

# pragma pack preprocessor dirictive specifies the byte boundary for packing members of c structures.syntax: #pragma pack(n)

Answer Question  Select Best Answer

nanis38

 Profile Answers by nanis38 Questions by nanis38

• Jun 16th, 2011

We can also find out by using DataProvider() function at report level

sumesh

• Mar 7th, 2007

Go to View -->structure...Here you can find the data providers name in Map tab..

Answer Question  Select Best Answer

Mohd Sarim

• Jul 13th, 2011

Info view is nothing but another name of web intelligence. we also call it BO thin client.

DeskI is thick client as we need software installed on the system to access BO reports etc whereas in case of WebI the BO installed on the server and we need to access it through our browser

Kumaresh Goplsamy

 Profile Answers by Kumaresh Goplsamy Questions by Kumaresh Goplsamy

• Jul 25th, 2007

Infoview is a portal to access the Business Objects in Web intelligence.? Business Objects???????????????????????????????????????????????????????????????? ??? web intelligence1.Multiple data providers...

Answer Question  Select Best Answer

vengi

• Jun 1st, 2012

Shortcut join: direct joins b/w the two tables by eliminating the intermediate tables.......the main purpose of this join is improve the performance of the query

BalamuruganS

 Profile Answers by BalamuruganS Questions by BalamuruganS

• Jun 1st, 2011

Locking of universes:When you are to import a universe , you will be going to File->Import.A dialog box opens where you can browse the universe you want to open.If you double click on the universe ...

Answer Question  Select Best Answer

What are isolated joins? whether there will be any problem if we have isolated joins in our universe?

Sudheer Vemulapally

• Nov 23rd, 2013

An isolated join is one that has not been included in any context in your universe. Once you start using contexts in a universe, every single join must belong to at least one context. A join can belon...

Kishore

• Jul 5th, 2012

Hi ......
Isolated joins is ex: i have 15 table A is 7 table B is 7 Table taken last is missing in the table that is the Isolated Joins

Answer Question  Select Best Answer

Derived has the same method as that of super class method

purvanshu

 Profile Answers by purvanshu Questions by purvanshu

• Jan 26th, 2014

Same method name with same signature (return type,arguments..) in both super class and subclass is method overriding.

Answer Question  Select Best Answer

T.Sreenu

• Jul 2nd, 2014

Alias is to resolve the loop between three tables and one Fact table , context is used to resolve loop between three tables and more than one fact Table

purvanshu

 Profile Answers by purvanshu Questions by purvanshu

• Jan 26th, 2014

Hi.... Hope it is useful..... Alias use to solve Fan Traps problem in Fan Traps problem 3 tables will be participate, table A connected to table B with one-to-many relationship, table B connected to...

Answer Question  Select Best Answer

A join that links two tables by bypassing one or more other tables in the universe.

sreenu

• Jul 2nd, 2014

Shortcut join is a join , It is an alternative path between the tables .
By using shortcut join we can improve the performance of query and decrease the join path.

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 19th, 2009

A. short cut joins are used to improve the query performance at universe level i.e. for performance tuning. Suppose if we have 4 tables A,B,C and D A--->B---->C---->D and there is a chance to...

Answer Question  Select Best Answer

If we have a user group and we want to give the access to the report from 1990 to 2000. and from that group we want one user to restrict to see the report from 1990 to 1995. Then what to do in BO designer, so that this can be possible( Not in report level).

T.sreenivasulu

• Aug 15th, 2014

Best answer is using row level restriction for 1990 to 1995

vishwanath_bhambure

 Profile Answers by vishwanath_bhambure Questions by vishwanath_bhambure

• Jul 15th, 2014

Restrictions are joined by default by "AND" Clause. So, If user has subscribed to two restriction that two restriction will joined by and for that user. So suppose current user is member of two restri...

Answer Question  Select Best Answer

Tak

• Dec 4th, 2014

You can create Groups in CMC

sharmampooja

 Profile Answers by sharmampooja Questions by sharmampooja

• Apr 28th, 2009

Their is no option to create groups in Designer, you have to use CMS to create groups.RegardsMohit

Answer Question  Select Best Answer

What is joinpath problem?

venkatesh

• Dec 26th, 2014

JOIN PATH PROBLEMS

1)LOOPS
2)TRAPS

Loops can be resolved using 1)alias(can completely solve loops)
2)contexts(can only cover loop,not completely solve the loop)
Traps can be solved by using

1)chasm trap
2)fan trap

muralikrishna1982

 Profile Answers by muralikrishna1982 Questions by muralikrishna1982

• Aug 27th, 2008

The join path problems areee loops, chasmtraps, fantraps..these can be solved by using 1) visualising analysis of schema2) by  using aliases3) by using contexts

Answer Question  Select Best Answer

Sarojini

• Nov 12th, 2016

We can set the security at Universe level and provide access to only specific Group to get their Region data

Abhishek

• Oct 13th, 2015

You can create a publication and schedule reports according to different location.

Answer Question  Select Best Answer

PRASAD

• May 16th, 2019

Filters applied at Universe objects level restrict data for every user This indicates filters at universe object bring restricted data to micro-cube where the users at report doesnt have control ove...

Aditya

• Feb 10th, 2015

Do the filters created the Universe level do any filtering of data that the Universe level also or they are just created to facilitate common filtering criterias at the report level

Answer Question  Select Best Answer