2008r2 Cube not linking two views on key

Question

Post reply

2008r2 Cube not linking two views on key

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Ryan1 (6/18/2014)
This works you are the man! Thank you so much.
Any chance I can make this thing smaller?

Glad you got it resolved.

What do you want to make smaller?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ryan1 Ten Centuries Points: 1019 More actions · Answer 2

Koen Verbeeck (6/18/2014)
Ryan1 (6/18/2014)
This works you are the man! Thank you so much.
Any chance I can make this thing smaller?
Glad you got it resolved.
What do you want to make smaller?

The cube itself is massive. After completing your steps: it seems to increase by a few megabytes every time I hookup a new dimension. It looks like it's creating a new dimension for EVERY key + a new dimension for every dimension that should be hooked up for that key.

Ryan1 Ten Centuries Points: 1019 More actions · Answer 3

Sorry to keep bringing this up guys but I've been banging this around for more than week now, took an online course, and have been working through microsofts tutorials and have found nothing. Can anyone point me in a direction of some readings that may suit the topic?

Please let me know if I should provide any more information, thank you and have a nice day.

Nevyn SSChampion Points: 14210 More actions · Answer 4

So now the question is just size?

That is pretty tough to answer without getting into specifics (how big is too big? do you need all the data you are including? etc)

You could look at working in ROLAP mode instead of MOLAP, which would save space in the cube, but make things slower (and increase space usage someone in the dw). Other than that, your only method I know of is getting rid of things you don't need.

Ryan1 Ten Centuries Points: 1019 More actions · Answer 5

Nevyn (7/4/2014)
So now the question is just size?
That is pretty tough to answer without getting into specifics (how big is too big? do you need all the data you are including? etc)
You could look at working in ROLAP mode instead of MOLAP, which would save space in the cube, but make things slower (and increase space usage someone in the dw). Other than that, your only method I know of is getting rid of things you don't need.

I will do my best to answer this fully:

The issue is size. The data is correct, and the measures can be reported along with the dimensions in the same cube.

When I convert the cubes over from Analysis Services 2000 they are but 2 or 3 megs a piece. Unfortunately, when I create the cubes from scratch using Koen Verbeeck method, stated previously in this thread, the cube can easily climb to over 80 mb while only hooking up a few dimensions and I need to hook up many more.

Also, ROLAP option is not my first choice because this scenario will not be fast enough.