-
AS OF DATE Filter to automate
Hello Guys,I am creating a WEBI from my universe which is using ORACLE database as backend. I have the following query which i need to automate. For that i need to create a filter in the unvierse i don't know which statement i should write in the universe filters.SELECT WMB.DEPOSITS_TXN_DETAIL.AS_OF_DATE, WMB.DEPOSITS_TXN_DETAIL.TXN_CODE, WMB.DEPOSITS_TXN_DETAIL.TXN_POSTING_DATE, WMB.DEPOSITS_TXN_DETAIL.SYS_SUB_PROD_CD,...
Balajikaadi
- Jun 11th, 2008
Hi,This can be handled as a condition object. Understand from the filter name (as of date) The condition object query should only contain the below statement. But of course.. you should have the assoc...
-
Hyperlink in Webi reports
Can any body says how to link 2 reports using hyperlink in webi reports ?
nishamakhija21
- Aug 22nd, 2008
To link 2 report I can explain with example, say you have 2 reports: "Primary Report" and "linked report", say you have 'year' and 'revenue' objects in primary report, and you wanna apply link on 'yea...
-
Universe Creation Issues
What are the common issues faced during creation of universe?
-
Connection
Set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and path to the database. Designer provides three types of connections: secured, shared, and personal.
ravi_kumar_garre
- Nov 13th, 2007
BO Designer supports three different types of connections, each denoted with a unique symbol in the list of connections:1. Personnal connections that users may create for freehand SQL or that universe...
sithusithu
- Jan 27th, 2006
A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database.Cheers,Sithu
-
Detail object
An object qualified as a detail provides descriptive data about a dimension object. A detail object cannot be used in drill down analysis.
ravi_kumar_garre
- Nov 20th, 2007
A Detail object provides additional information about a particular dimension. A Customer dimension, age, fax, phone number, street address and direct mail are typical details. Details and attributes m...
sithu
- Apr 19th, 2006
Defined role that object takes when used in the Query panel. You can qualify an object as being one of three types:DimensionDetail Measurel detail objects holds more information about you measure and dimension, but you can't drill that based on your detail objectsCheers,Sithu, sithusithu@hotmail.com
-
Document domain
The area of the repository that stores documents, templates, scripts, and lists of values.
ASHOK1324
- Apr 19th, 2009
The area of the repository that stores documents, templates, scripts, and lists of values.
-
Enterprise mode
A work mode whereby a designer creates universes in an environment with a repository. The mode in which a universe is saved determines whether other designers are able to access it. By default, a universe is saved in the mode in which the designer is already working.
ravi_kumar_garre
- Nov 20th, 2007
Within BusinessObjects enterprise, user names can be authenticated against one of more security databases. The default authentication source is Enterprise. However, if your company uses Windows NT, for example then NT user name and password can be used to log into Designer. Cheers,Ravi Kumar Garre
sithusithu
- Jan 30th, 2006
Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your universe determines whether other designers are able to access them.Cheers,Sithu
-
Hierarchy
An ordered series of related dimensions used for multidimensional analysis.
ASHOK1324
- Apr 19th, 2009
Hierarchy is an arrangement of objects for report to report interactions [RRI]. It is used for drill-down and drill-up operations in universe design.
sithusithu
- Jan 27th, 2006
a series of dimensions used for analysis based on user requiermentsCheers,Sithu
-
How do you design a universe?
The design method consists of two major phases. During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.During...
ravi_kumar_garre
- Nov 21st, 2007
Universe Design as follows:Define Parameters -> Insert Database Schema (tables, columns..etc)->Make the Joins->Resolve the loops->create classes and Objects->Hierarchies.Then test the universe for integraty.Cheers,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in
sithusithu
- Jan 27th, 2006
The design method consists of two major phases.During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and t...
-
What is the drill up , drill down, drill by , drill trough ?
drill up : One level up in the HirearchyDrill down: One level down in the Hirearchydrill by : direct selection of level in the Hirearchydrill trough : to drill data from one Hirearchy to another Hirearchy
pavanbo
- Jul 20th, 2010
Drill up means up in the hierarchy.Month:-Quarter:-YearDrill down means down in the hierarchyYear:-Quarter:-MonthDrill through means you can drill through to the database directly from drill mode and get the required dataDrill by means you can select one hierarchy to another hierarchy
sithusithu
- Jan 27th, 2006
Drill up : UP-one levelDrill down: DOWN-one levelDrill by : selection of level HierarchyDrill trough : Hirearchy to another HirearchyCheers,Sithu
-
-
How will you know the version of Bo using designer?
fani_ece
- Jun 22nd, 2007
Go to help and click About Designer in help, you will find it.
sithusithu
- Jan 4th, 2006
Select the component business object DesignerNow it will prompt for userid/password/security domainYou will find a Help button, click that and find out what ever you want Cheers Sithu
-
How to Implement the the Built-in Strategy Script in BO Designer?
Kumaresh Goplsamy
- Jul 25th, 2007
Hi,universe is provided with default strategy also known as built in strategy.if you want to create new strategy, edit the .SBO file and mention your strategy ,and this strategy ...
mayuri
- May 4th, 2006
Using quick design wizard for developing the universe will invoke the built-in strategy
-
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?Database in use is Oracle.
pat.mclean
- Jun 14th, 2006
well adi,it is not a table name, but column name(sales_date).It can be any name depending upon your ETL process & naming convensions. if you have the database ready & you want to break yo...
Adi
- Jun 9th, 2006
Pat,Do i need to have some tabel selected like u have mention sales_date?
-
-
Hi AllCan any one explain the Aggregate tables and how is that helps in fine tunning the performance, Please give an example not the one which is in PDFs.Appreciate your help.Thanks All
Kumaresh Goplsamy
- Jul 25th, 2007
Hi, Aggregate table is a pre defined table.calculate the aggregates and store the values in one table.Instead you ask query to generate aggregate every time you just give reference to...
Sravan Gopisetty
- Sep 14th, 2006
Hi,Is that Aggregator Transformation or Aggregator Tables.If it is Aggregator Transformation then it CALCULATES the summery values like SumSAl,AVGSAL,MAXSAL,MINSAL FOR EACH GROUP WISE.FOR EXAMPLE...
-
-
Hi all can u tell me the differnec between BO 6.5 and B.OXI -R2
muni krishna reddy
- Jun 1st, 2007
BO XI archi. is completely different from its previous versions. It was completely built on crystal reports archi. In XI we don't save docs in repository. we will save them as physical data known as f...
Latha03
- Jan 25th, 2007
In BO 6.5 either subordinates(Designer,Reporter) or Supervisor can have more or less rights independent of their positions.In BO XIR2 the rights are inherited from the supervisor to the subordinates(Designer, Reporter).
-
-
What is row level security
sri_emd
- Jul 29th, 2010
The measure of specifying which rows a user can retrieve based on a column of data or combination of columns is called row level security
Kumaresh Goplsamy
- Jul 25th, 2007
HI, It is a security implemented by the supervisor for accessing particular data from the database . This can be done by 1.login to BO supervisor .2.Go to universe tab3.select the&nbs...
BO Designer Interview Questions
Ans