How to Create Cube ?

[jaganlalrm]

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 

[Ganesh Kedari]

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.

[jaganlalrm]

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

[Lynn]

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.

[jaganlalrm]

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

[Ganesh Kedari]

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

[MFGF]

Just filling in the gaps... :)

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.

[jaganlalrm]

Thank you very much :)

[jaganlalrm]

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

[MFGF]

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:

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.