dbTalk Databases Forums  

APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ??

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ?? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hkappleorange
 
Posts: n/a

Default APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ?? - 09-21-2005 , 05:49 AM






Apart from SQL Server AS, any cube editor (free 3rd party) out there ???

Pls help



Reply With Quote
  #2  
Old   
dbahooker@hotmail.com
 
Posts: n/a

Default Re: APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ?? - 09-22-2005 , 03:15 AM






what do you need to do??


Reply With Quote
  #3  
Old   
hkappleorange
 
Posts: n/a

Default Re: APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ?? - 09-22-2005 , 08:44 AM



I wish to combine 2 cubes with same dimensions. One cube contain measures of
actual and another cube contains actual measures.

I want to bring 2 cubes into one pivot tables in Excel.
Thanks.

<dbahooker (AT) hotmail (DOT) com>
???????:1127376906.543019.189630 (AT) g14g2000cwa (DOT) googlegroups.com...
Quote:
what do you need to do??




Reply With Quote
  #4  
Old   
dbahooker@hotmail.com
 
Posts: n/a

Default Re: APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ?? - 09-23-2005 , 08:43 PM



you can do a virtual cube to combine them

make sure your dims are named the same

good luck


Reply With Quote
  #5  
Old   
hkappleorange
 
Posts: n/a

Default Re: APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ?? - 09-25-2005 , 06:47 AM



Thanks but is it possible to do so without SQL server ??


<dbahooker (AT) hotmail (DOT) com>
???????:1127526230.374622.150240 (AT) g14g2000cwa (DOT) googlegroups.com...
Quote:
you can do a virtual cube to combine them

make sure your dims are named the same

good luck




Reply With Quote
  #6  
Old   
Jéjé
 
Posts: n/a

Default Re: APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ?? - 09-25-2005 , 03:08 PM



I think its not possible to create a virtual local cube

the simple way is to do it at the server level.

another way is to create your own local cube by using excel. but you have
limited fonctionalities and its a hard & long process.

so try to access your server first.


"hkappleorange" <hkappleorange (AT) yahoo (DOT) com.hk> wrote

Quote:
Thanks but is it possible to do so without SQL server ??


dbahooker (AT) hotmail (DOT) com
???????:1127526230.374622.150240 (AT) g14g2000cwa (DOT) googlegroups.com...
you can do a virtual cube to combine them

make sure your dims are named the same

good luck






Reply With Quote
  #7  
Old   
dbahooker@hotmail.com
 
Posts: n/a

Default Re: APART FROM SQL S., ANY CUBE EDITOR (FREE 3RD PARTY) ?? - 10-07-2005 , 05:02 AM



yeah you can do offline cubes in Excel

SQL Server is the best DB anywhere though; buy a copy and kick Oracle
and the half-dozen unix architects out the window


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.