CUBE - Creation ?? 
Author Message
 CUBE - Creation ??
What is the difference between creating a Cube using the
SQL Analysis Server and Pivot Table Wizard in Excel...


Tue, 22 Mar 2005 22:29:03 GMT
 CUBE - Creation ??

the AS cube is stored on a server and it can handle large cubes and some
particular dimensions.
Also AS can use different storages, can aggregates your data, can partition
your cube, manage the security...

Excel can create a local .cub file (a copy of the server cube, but with some
restrictions)
and Excel can creates a cube from any datasource with some restrictions
again. also, there is no interface like the management console of an AS
server, to play with your dimensions, facts, calculated members...



Quote:
> What is the difference between creating a Cube using the
> SQL Analysis Server and Pivot Table Wizard in Excel...



Tue, 22 Mar 2005 23:51:20 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Alternative Regular Cube creation besides Cube wizard/Editor method

2. Analysis Server & Remote Cube Creation Problem

3. Is any C++ sytax or sample for Cube creation

4. any guides on this? (cube creation)

5. Cube creation

6. Global Cube Creation BUG (675)

7. basic cube creation

8. Is there Any C++ syntax/sample for cube creation (.cub)

9. Dynamic cube creation

10. Problem: Define Custom member on local cube creation (Not measures dimension)

11. help for two text tables(dim and FACT table) for local cube creation.


 
Powered by phpBB® Forum Software