Creating cube

[cognos8guy]

Hello,
  I am new to COGNOS. Can any one tell me how to create a cube in transformer.

What are the steps involved in creating a cube in transformer.


Thanks in advance

[djagger]

Six simple steps for building your own cube in Transformer...- Create a datasource for your cube
- Open Transformer and connect to the datasource
- From the datasource window, Drag and Drop the data items that you want in your "Dimensions" by proper hierarchy
- Finally, Drag and Drop Fact items from your datasource window to the "Measures" window
- Check and Validate your cube model and finally
- Run your cube model to build your cube

[vijayab]

Hi Welcome to cognos

First thing while creating a Cube u need to have data source .
Insert a data source like iqd(impromptu Query Definition),Excel sheet,MS Access table etc.
Then establish the joins between the different data sources by giving a same column name.
Then Create dimensions by dragging particular column name from data source and drop it to the dimension map workplace .
same way drag numerical field  column from ur data source and drop it to the MEASURE pane.
In cube pane right click and include a Cube with location on ur machine and say Create the Cube..

These r the common steps need to follow to create a Cube!!


Hope it will help u

good luck!!

vj :)

Hello,
  I am new to COGNOS. Can any one tell me how to create a cube in transformer.

What are the steps involved in creating a cube in transformer.


Thanks in advance

[gnanasekaran.be]

Hi vijayab,

creating cube is fine...I am not able to set levels in dimension,So pls tell me how to  set the levels (ie) Hierarchy structure

for example in time dimension year-->Qtr-->months

Thanks & Regards ,
Mr.G

[happy]

hi vijayab
as u said........"Then establish the joins between the different data sources by giving a same column name."
i want to know how can we establish such joins by giving a same column name?wat are the general rules for doing dis?

suppose i hv tables(in bold) with columns(in brackets) as :

TITLES(ttitle_id, title, type, pub_id, price, advance, royalty, ytd_sales, pubdate)
SALES(stor_id, ord_num, ord_date, qty, payterms, title_id)
STORES(stor_id, stor_name, stor_address, city, state, zip)
PUB_INFO(pub_id)

plz help
urgent

[vijayab]

TITLES(ttitle_id, title, type, pub_id, price, advance, royalty, ytd_sales, pubdate)
SALES(stor_id, ord_num, ord_date, qty, payterms, title_id)
STORES(stor_id, stor_name, stor_address, city, state, zip)
PUB_INFO(pub_id)


with join the tables look like this

TITLES(ttitle_id, title, type, pub_id, price, advance, royalty, ytd_sales, pubdate)
SALES(stor_id, ord_num, ord_date, qty, payterms, ttitle_id)
PUB_INFO(pub_id)

as in ur cube if u r  ur  not taking any fact value from the table PUB_INFO keep it as it is!!

hope it will help u!!:))

best regards,
vj