dz2k7
Not only User
- Local time
- Yesterday, 18:18
- Joined
- Apr 19, 2007
- Messages
- 104
Pls don't kick me for beginner's questions, but...
I'm using Cognos to see OLAP cubes and build reports.
The cubes has been built by another department.
I'll have SQL server soon.
I know thet SQL server can create and keep those structures.
2 questions:
1. Do I need any specific software to create and work with those cubes or SQL server itself is enough?
2. As I see in Cognos those cubes consist of dead numbers, downloaded from the database from time to time. Than we can summarize some data or make slices of the cube in any dimention. The question is can I have formulas in each cell of the cube? Just like I can have in Excel spreadsheet.
For instance can I multiply one cube by another and get the tird one, having the results?
thank you
I'm using Cognos to see OLAP cubes and build reports.
The cubes has been built by another department.
I'll have SQL server soon.
I know thet SQL server can create and keep those structures.
2 questions:
1. Do I need any specific software to create and work with those cubes or SQL server itself is enough?
2. As I see in Cognos those cubes consist of dead numbers, downloaded from the database from time to time. Than we can summarize some data or make slices of the cube in any dimention. The question is can I have formulas in each cell of the cube? Just like I can have in Excel spreadsheet.
For instance can I multiply one cube by another and get the tird one, having the results?
thank you