COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Shobha on 25 Jul 2007 06:12:24 AM

Title: Cubes in cognos 8
Post by: Shobha on 25 Jul 2007 06:12:24 AM
Hi
I am fresher in cognos 8. I am having a doubt regarding cubes.
Where should we create a cube(in analysis studio? or where) and how to use it?

Thanks in advance.
Title: Re: Cubes in cognos 8
Post by: swordfish on 26 Jul 2007 03:48:07 PM
Hi shobha,

Analysis Studio is like PowerPlay (Series 7). It is used for Cube Browsing and analysis purpose. For creating cubes, you need to use Transformer.

You can design your dimensions, levels etc in the transformer and create cubes with Transformer.

And what ever cubes you create can be opened (accessed) using Analysis Studio. Cube reporting also can be done using Analysis Studio.

SF
Title: Re: Cubes in cognos 8
Post by: Shobha on 26 Jul 2007 10:58:25 PM
Thanks SF.

Finally my doubt is cleared. I know sql server SSAS,SSRS. So, i thought same concept is followed in cognos. But i could not find the same in cognos.

What is the main diffrence between Query,Analysis and Report studio. As i am finding all three are used for creating reports ?
Title: Re: Cubes in cognos 8
Post by: MDXpressor on 30 Jul 2007 12:03:20 AM
Query Studio is best used for simplistic reports for a Relational source; Analysis Studio is for simplistic analysis of Dimensional sources; and Report Studio is for creating complex reports using either source.
Title: Re: Cubes in cognos 8
Post by: snadgir30 on 30 Jul 2007 01:06:42 AM
Hi Shobha,
I would like to add few points to SF's reply.

Query Studio - used by end business users to imagine/present idea/type of report to be demanded from report author.

Report Studio- Report Authors in turn create reports as requeted by Business user  in report studio.