COGNOiSe.com - The IBM Cognos Community

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

- 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

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 :)

Quote from: cognos8guy on 24 Jun 2008 12:52:36 PM
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

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

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

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