In cognos 'group' is used to suppess the duplicate 
values..and 'associate' is used to suppress the values if 
it is one-one relationship.

Group - It Eliminates the Duplicate values from the report 
break the columns . its having a one to many relationship.
Association-

It Eliminates the Duplicate values from the report and its 
having one-one relationship....

Both Group& Association eliminte duplicatesin a column.
But we can not use Association alone.
It should have one to one relationship with grouped column.

Using Association is a performance enhancement technique.

A GROUP IS USED TO ELMINATE THE DUPLICATES IN DATA.WHERE A 
ASSOCIATION IS USED TO HIRE OR SUPPRESS THE VALUES IN 1 TO 
1 RELATION.

You mean PowerPlay??????

Wt is pp..???

In powerplay for windows, we can add dynamic titles by 
including current column variable.If we use this variable 
in the title,during drill down and drill up of the the 
report the title changes automatically.
steps:
Format Menu -> Title.
In the title window,click Insert button
Add the variable 'current row' and type the required field.
for eg, current row by Location,insert picture if u want 
and drag in the title area.
It looks like <none> by location with picture,at the title 
area.
when you click the current row , the title changes 
automatically.
for eg,if its in outdoors product,the title will change as 
"outdoor products by Location" and so on ..

First you have to click on column header which you have to 
change. Then in property pane you will found name option. 
Then change  column name .

Hi ,
If you want to change the name of columns of tables then 
open that particular catalog click on Catalog option on 
Menu Bar then Click on Folders and then expand the ur 
paricular Tables folder then select the column which u want 
to change the name and then  Click on Edit  button at the 
right hand side.and give the name u want.      


Thanks & Regards,
VIJ

in transformer u import metadata from architect or catalog 
to create a cube. we just imprt metadata. we dont add data 
to it

By using the Framework Manager we can create measures and 
dimensions according to our business needs.

Question is bit confusing..

First of all, when you design model in FMW, you will derive 
new (calculated) measure thru existing KPI/Measure. Like 
Qty, Sales Amt, Rate, Discount etc. From this KPI, you can 
derive new measure. 

Otherwise, when you design DM for a organization, you need 
to study the sytem, you define Dimension, where all master, 
and heirachies are there. Difine a Fact Table with All KPI, 
Measures/Numbers.

And then you join PK in Dimension Tables with FK in Fact 
Table. 

This is dimensional modeling in dw. this db can used in 
FWM, to create package, where you create calculated measure.
 

rgds,
palz

IQD is impromptu Query Defination. It's a transformer 
report. to use an IQd in reportnet framework manager,there 
is a process called externalization using which you can 
import the IQD.

IQD Is impromptu query definition, the name it self 
indicating dat , it contains the SQL statement. To create 
the iqd in Frame work manager, Create a new query subject 
with required query items .Set the Externalise method 
property of that Query subject to 'iqd'.

while the publishing the package select the 'Generate the 
files for Externalized query subjects'. and publish it to 
the local machine, which can be used as data source for 
Transfromer model.

Loop is an very dangerous exception in framework manager we 
can resolve the loop create alias table. loop Dispaly wrong 
results in the reportnet.
 
A Loop is a Closed Path Circuit....

avoid loops:using shortcuts.
we have ambiguous relationships types:
hierarchical relationships,recursive relationships,multi-
valid relationships.to avoid these relationships using 
shortcuts.

hi

cube can be created by using different data sources.
data sources: iqd, tex file ---

cube creation by using iqd data sources.
1)these iqd sources are coming form immpromptu

1.Analyze user reruirements
2.Determine the source data
3.Build the model and define source data
4.Organise the dimensions,levels,categories,measurses
5.Refine the model
6.create the required cube and consider cube 
groups;location where to sstore cube
7.give access privileges for each user 
8.Deliver the cube based on user located 
9.Distributed the cubes via vss or any other resources
10.give the production support

A SnapShot is a Permenant Local Copy Of The Report Data a 
Sanpshot is Static DataSource it is saved with .imr File it 
is suitable for Disconnected Network....

client gets the information. that information is not in the
order.they r unable to under stand info.it can not helpfull to 
take the decessions. then the clint meets the company.

Clent first contacts the company's Business
DevelopmentManager of the company, Then Meeting and a chat
happens in a clients place or client coming to company, Then
gets the requiement according to the deal

Hi Everyone,

  This is Ajmal from Bangalore,working as a BDM. can u pls
let me know the different ways of getting clients....?


Thanks & Regards,
Ajmal Khan

To prompt the values  and it is used on where condtion 
and filter row 

syntax

@select(class\object )= @prompt 
('message','type','{values1,values2...},class\object,mono\mu
lti,free\constrained)

it is nothin but a dialog box
it can used for to take the values.
syntax:
 
@prompt('message',['type'],[lov],[mono/multi],[free/constraint])

HI this is Narasimha,

Prompt: It is used to create an interactive object. and 
also it is dynamic filter. 

General syntax:@prompt('message',['type'],[lov],
[mono/multi],[free/constraint])

In designer we can write this way,
@select(class\object )= @prompt 
('message','type','{values1,values2...},class\object,mono\mu
lti,free\constrained)).

Cascading Prompt: it is based on one prompt to another 
prompt. it is also refer to hirerchy also & designed in uni 
level.
IN BOXIR2 wise:--
 go tools --> click cascading lov -->  edit lov window 
open --> write conditions how many prompts u want. --> 
click ok.

action of navagating thorough levels of data.
by drill down youn can reach the more refined or detailed
information.

analysing the data in different angles and levels

Drill down is a one of the concept in Drill.
Drill is nothing but an action of navigating data thru 
levels of data. Drill down - with the use of drill down you 
can reach more detailed information.

Navigating data to lower level in the hierarchy with in the 
cube

move from summary information to detailed data.Drilling the 
data into end level of hierarchy

slice and dice is to arrange the the data in differnt ways.
it can chage as rows to columns  and columns to rows.

The ability to move between different combinations of 
dimensions when viewing data with an OLAP browser.

Multidimensional analysis tools organize the data in two 
primary ways: in multiple dimensions and in hierarchies.

Slicing and dicing refers to the ability to combine and re-
combine the dimensions to see different slices of the 
information. Picture slicing a three-dimensional cube of 
information, in order to see what values are contained in 
the middle layer. Slicing and dicing a cube allows an end-
user to do the same thing with multiple dimensions.

define scope of analysis.
define condiations.
create master and detail reports.
add formulas,local variables and functions
breakeup tables and disply tha calculations.
create charts.
analyze the data in drill mode.
use slice and dice.
formate reports.
export reports.

most of the reporting tool had same features but bO is more 
secure..can work with remotely using web I,with out 
installing of BO s/w in ur local system

data warehouse is used for to store the large volumes of
data.it can be used for future forecasting.it is the
collection of key pieces of information that can be used for
to take the dession by the managers.

The main aim of data warehouse is in analyzing the large
volumes of data so that it can be helpful in taking business
decisions

for reporting one day details also enough.but analysis 
means we need comparision means we need some old data is 
called historical data.the data ware house saves historical 
data ,we con't to any data base manuplations.


where is in normal databases we arte able to maintain some 
extent of data .after that for entering new data u need to 
delete the old data.

BUT in Data ware house u are able to stote years of records 
no need to delete the old data