Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Joining Cubes

  
   Database Help (Home) -> OLAP RSS
Next:  "time" a query  
Author Message
jeffc

External


Since: Jan 04, 2005
Posts: 58



(Msg. 1) Posted: Sun Dec 28, 2008 4:28 am
Post subject: Joining Cubes
Archived from groups: microsoft>public>sqlserver>olap (more info?)
I am a novice with SQL Server slowly learning about OLAP Cubes and proper
design. Is there a way to join two OLAP Cubes? Is there a good reference
someone could point me to? Are there opinions about different methods or
strategies on these kind of joins?

Thanks in advance

--
Jeff C
Live Well .. Be Happy In All You Do

 >> Stay informed about: Joining Cubes 
Back to top
Login to vote
Jesse O

External


Since: Jan 25, 2008
Posts: 23



(Msg. 2) Posted: Mon Dec 29, 2008 1:52 pm
Post subject: Re: Joining Cubes [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
in AS2000 you use virtual cubes

SSAS2005/08 you can use linked measure groups

"Jeff C" wrote in message

> I am a novice with SQL Server slowly learning about OLAP Cubes and proper
> design. Is there a way to join two OLAP Cubes? Is there a good reference
> someone could point me to? Are there opinions about different methods or
> strategies on these kind of joins?
>
> Thanks in advance
>
> --
> Jeff C
> Live Well .. Be Happy In All You Do

 >> Stay informed about: Joining Cubes 
Back to top
Login to vote
jeffc

External


Since: Jan 04, 2005
Posts: 58



(Msg. 3) Posted: Mon Dec 29, 2008 4:34 pm
Post subject: Re: Joining Cubes [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
--
Jeff C
Live Well .. Be Happy In All You Do


"Jesse O" wrote:

> in AS2000 you use virtual cubes
>
> SSAS2005/08 you can use linked measure groups
>
I should have been more clear in that we are using SQL Server 2005

I am still learning, could you explain in more depth or point me to a
reference on how to use linked measure groups?

Thanks for your help


snip


>
 >> Stay informed about: Joining Cubes 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Migrating cubes - I tried to install 2005 and faild to migrate old cubes. So uninstalled old analysis server after taking the backup. I had restored the backup in some other machine and trying to connect using the latest 2005 analysis server migration wizard. But..

Compare Cubes - Hello, I'm in a testing fase, mostly on different approaches of design, and i would like to compare the finally generated cubes on their number of cells, indexes, ..... In the standard reports i havn't found a report that gives you a dump on each..

To many Cubes and dimensions? - I have an OLAP database with 150 cubes and each of the cubes have 12 dimensions. Response times of MDX queries are fine, but Processing times of the cubes seems to be increasing as I add more cubes. If the cube is the only one in a database it takes onl...

slow Cubes - All cubes we have used have been relatively small. I have this analysis where I only have like 12,000 rows in the main dimension (contracts) - and I'm displaying 4 columns and 3 rows in my Excel 2007. When I click one more attribute from my Contract....

Large Cubes and Security - Hi I just want comfirmation that is a best practice. I have a very large cube that is going to be used by many customers in SSAS 2005. Now my some of my dimesions can be in 1000's of records and I can have 100's of customers. To secure the data in..
   Database Help (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]