COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: jaganlalrm on 23 May 2013 04:31:22 AM

Title: How to Create Cube ?
Post by: jaganlalrm on 23 May 2013 04:31:22 AM
How to Create Cubes?

we need Powerplay Transformer or using Framework itself we can create Cube.

After Creating Cube. Using that how to create Reports Using the Cube.

Advance Thanking you.

Please Tell about the Cubes 
Title: Re: How to Create Cube ?
Post by: Ganesh Kedari on 23 May 2013 06:02:28 AM
Hi jaganlalrm,

This is very generic question. I will suggest it will be more useful if you can put your exact requirements.
We can use Transformer for creating Cognos Powercube and use to create report on top of it.

You can take a look at product documentation for the various details about the products.
Title: Re: How to Create Cube ?
Post by: jaganlalrm on 23 May 2013 06:31:39 AM
Hi Ganesh Kedari,

i want to create cube using that i want to create report

For this which are all tools i need to do create cube using that create report

Thanks in Advance

_________________________________________________________________________________________________
Jaganlal.R.M

Title: Re: How to Create Cube ?
Post by: Lynn on 23 May 2013 08:11:29 AM
You can create Power cubes using Transformer.
You can create TM1 cubes using some other tool I can't remember the name of.
You can create a DMR model using Framework Manager.
You can create dynamic cubes in 10.2, but not sure what is used to create those.

You can create reports from Power cubes or DMR models using Report Studio or using Business Insight Advanced/Cognos Workspace Advanced. You could also use Analysis Studio or even Query Studio (even though it isn't member-aware) but I wouldn't recommend either of those. I'm less familiar with TM1 and dynamic cubes, but I imagine Report Studio and BIA/CWA are applicable there also.
Title: Re: How to Create Cube ?
Post by: jaganlalrm on 23 May 2013 08:53:59 AM
Hi Ganesh Kedari,

Thanks for your information

And tell me about what is mean by DMR model. Before i have use to create package by create Query.

Tell How to create DMR Model in FrameWork Manager.

Thanks in Advance
Title: Re: How to Create Cube ?
Post by: Ganesh Kedari on 23 May 2013 09:04:38 AM
Hi ,
Find Link for Framework manager user guide. You can refer Modeling Relational Metadata section to create DMR .
http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm.html
Title: Re: How to Create Cube ?
Post by: MFGF on 23 May 2013 09:10:04 AM
Just filling in the gaps... :)

Quote from: Lynn on 23 May 2013 08:11:29 AM
You can create Power cubes using Transformer.
You can create TM1 cubes using some other tool I can't remember the name of. Architect or Perspectives or Performance Modeler or even Cognos Insight
You can create a DMR model using Framework Manager.
You can create dynamic cubes in 10.2, but not sure what is used to create those. Cube Designer

You can create reports from Power cubes or DMR models using Report Studio or using Business Insight Advanced/Cognos Workspace Advanced. You could also use Analysis Studio or even Query Studio (even though it isn't member-aware) but I wouldn't recommend either of those. I'm less familiar with TM1 and dynamic cubes, but I imagine Report Studio and BIA/CWA are applicable there also. Yes - they are applicable with TM1 cube packages and Dynamic Cube packages too - also with Query Studio and Analysis Studio if desired.
Title: Re: How to Create Cube ?
Post by: jaganlalrm on 23 May 2013 09:43:42 AM
Thank you very much  :)
Title: Re: How to Create Cube ?
Post by: jaganlalrm on 23 May 2013 09:45:38 AM
Hi Lynn

Thanks for your information

And tell me about what is mean by DMR model.

Tell How to create DMR Model in FrameWork Manager.

Thanks in Advance
Title: Re: How to Create Cube ?
Post by: MFGF on 23 May 2013 10:17:07 AM
Quote from: jaganlalrm on 23 May 2013 09:45:38 AM
And tell me about what is mean by DMR model.

Tell How to create DMR Model in FrameWork Manager.

Thanks in Advance

Ganesh already posted the answer to this above:

Quote from: Ganesh Kedari on 23 May 2013 09:04:38 AM
Hi ,
Find Link for Framework manager user guide. You can refer Modeling Relational Metadata section to create DMR .
http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm.html

Cheers!

MF.