sar

• Apr 23rd, 2007

If you just need the query.select product,sum(case when date > 'xxxx' and date 'xxxx' and date

Answer Question  Select Best Answer

sar

• Apr 23rd, 2007

Additionally-- Follow naming convention -- Objects and conditions in a class should be either hierarchial or alphabetical-- Classes/ Sub Classes should be logical-- Organize the schema, no clutters of joins 

Kumar Ranu

• Apr 16th, 2007

I would like to add...Universe contains Dimensions and facts.These are linked with joins so there must be indexes on the dimensions table's columns and if nessesary fact table's columns.Mostly...

Answer Question  Select Best Answer

The graphical component within the main Designer window that lets you create the classes and objects of the universe from the tables and columns of a database.

Nithyadharmaraj

• Apr 10th, 2007

Table Browser is an independent window that displays the table available in the connected database.You can insert the tables into structure pane by double clicking the tables in the table browser r by...

Answer Question  Select Best Answer

Nidhii

 Profile Answers by Nidhii Questions by Nidhii

• Mar 14th, 2007

U r welcome Pat ;)).. if u have any queries in bo designer or reporter,u can always count on me. Regards,Nidhi

pat.mclean

 Profile Answers by pat.mclean Questions by pat.mclean

• Mar 13th, 2007

Hey Nidhii,Thanks a lot for your contribution.

Answer Question  Select Best Answer

Nidhii

 Profile Answers by Nidhii Questions by Nidhii

• Mar 12th, 2007

Hi,I can explain why a report performance is increased when we apply a filter at the universe level rather than at the report levelWhen we apply a filter in the universe level,after the query is fired...

Latha03

 Profile Answers by Latha03 Questions by Latha03

• Jan 26th, 2007

Avoid applying filters unless and until there is a requirement from client side. Thus we can increase the performance of the reporter.

Answer Question  Select Best Answer

Sujit

• Feb 22nd, 2007

Templates : They are predefined format of the report which you can re-use to create multiple reports with the same design look and feel. The way to create a Template is the create a normal BO report, ...

pinki

• Jul 15th, 2006

1.instead of selecting standard report format we can select the template in which we wish to fgenerate a report.for ex:-if we want our report to be in cross-tab format we can select that template.temp...

Answer Question  Select Best Answer

Sujit

• Feb 22nd, 2007

Infoview is a BI portal through which you can access the WebIntelligence and the 3-tier full client documents along with the word and excel files.Difference between 6.5 and BOXIR2 is,The architecture ...

Answer Question  Select Best Answer

zulfikar

• Feb 13th, 2007

kernel approachone universe contains the core components. These are the components common in all universes. The derived universes that you create from this kernel universe contain these core component...

Answer Question  Select Best Answer

BauV.QA

• Feb 12th, 2007

Hi,Open your Universe in Designer, just check "Prevent" optioin in UNIVERSE PARAMETERS>>SQL tab under CARTESIAN PRODUCTS title.Regards,Balaji V.

BauV.QA

• Feb 12th, 2007

Hi,Open your Universe using Designer and just check the "Prevent" option under 'Cartesian products' in Universe Parameters>>SQL tab.Regards,Balaji V.

Answer Question  Select Best Answer

vvk.kotamraju

 Profile Answers by vvk.kotamraju Questions by vvk.kotamraju

• Feb 10th, 2007

HiThe input context determines what dimension to go into the calculations to produce the values. whereas the out put context determines how the values are combined. It is generated by the cell location with the report.

Answer Question  Select Best Answer

The work mode appropriate for a networked environment in which the general supervisor has set up a repository.

rakesh

• Jan 29th, 2007

Online mode means working with u r repositoryit means that u have been logged on to u repository and u r using that universe

Answer Question  Select Best Answer

barbie

• Oct 6th, 2006

Cube :  Loal structure to hold the data returned by a queryschema:  graphical representation of databaseuniverse: symantic layer that isolates end user from  the comlex structure of databse

Answer Question  Select Best Answer

Siva Kumar Rachaputi

• Sep 2nd, 2006

Hi,I think you can create a dimension object with decode statement.decode(code,code_val1,'National',code_val2,'International',code_val3,'International'....)

Answer Question  Select Best Answer

tamiloli

 Profile Answers by tamiloli Questions by tamiloli

• Jul 25th, 2006

Measure objects is the logical subset of classes, It will carry only numeric values which is eligible for further calculation , It?s nothing but the facts in the schema . 

pinki

• Jul 20th, 2006

measure objects are the objects which have facts i.e all $ amountsa dimension object cannot be calculated with another dim objectin order to have a seperate identity for $ amounts we define as measure...

Answer Question  Select Best Answer

pinki

• Jul 22nd, 2006

1.each n every object n class must be given description so that it is very clear to non technical users also n each n every object must me given a understandable clear name so that by just looking at ...

Answer Question  Select Best Answer

A join that links two tables, one of which has rows that do not match those in the common column of the other table.

Suresh

• Jul 5th, 2006

Outer Join - method of retreiving selected rows from one table that doesn't match rows with the other table.Ex: Consider A & B two tablesSELECT eno, ename, a.dno, dname FROM a,bWHERE a.dno=b....

Answer Question  Select Best Answer

Suresh

• Jun 28th, 2006

Mr. Patrick McLeanI cant get u properly. Could u please explain in more detail about linking of 2 Data marts as well as clarify me if we have objects with diff data type in both the common table, how to link the mart in that cases.Waiting for your reply

pat.mclean

 Profile Answers by pat.mclean Questions by pat.mclean

• Jun 27th, 2006

yes, you can link 2 datamarts.if your common dimension (still 2 different instances) has similar column names & more important SIMILAR DATA( exact replica) but has different name,just add any 1 of instance (year_sal_dim or period_fin_dim) & refine your objects.

Answer Question  Select Best Answer

A join based on the equality between the values in the column of one table and the values in the column of another. Because the same column is present in both tables, the join synchronizes the two tables.

xinx0626

 Profile Answers by xinx0626 Questions by xinx0626

• Jun 28th, 2006

It is also called INNER JOIN

Xinx0626

• Jun 28th, 2006

It is also called INNER JOIN

Answer Question  Select Best Answer