Re: one fact table devided into two cubes

Tech-Archive recommends: Fix windows errors by optimizing your registry

You can do it that way as verbani suggested or you can create views on the
data warehouse that will produce the rows that you want and base the cubes
and dimensions off of the views.

David

"verbani" <verbani@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C80134A-542A-44E3-8C8F-DFC02C7E5209@xxxxxxxxxxxxxxxx
> It is possible. I'm not sure if I unstand you correctly but here goes:
>
> When you create a cube you also have a partition. When you edit that
> partition on the last screen of the wizard you get a button advanced. If
> you
> click on that you get a box where you can add a 'where' clause to the
> select
> analysis executes again your fact table. Here you can then choose for
> departementcode = 'xxx'
>
> I hope this helps.
>
> Regards,
> Nico
>
> "Kristoffer Mortensen" wrote:
>
>> Hi group
>> I'm having a problem with a huge dimension. The users of the cube are
>> not excited about the idea of adding levels to the dimension, but they
>> would rather have 2 cubes instead.
>>
>> The large dimension is customers, and they wish to have the cube divided
>> into two cubes by departments.
>>
>> I've not been able to find any info on this that gives me an idea on how
>> to do this.
>> The Filter Source Table I think should be used, but how do I restrict
>> the customer dimension to only show the customers related to the
>> specific departments in that subcube?
>>
>> So I need to "cut the fact table in half" including the values in the
>> dimensions. Is that possible at all?
>> There are only one tabel in this cube, the fact table. Each row has a
>> customer and a department field.
>>
>> I hope I made myself understandable, and someone could tell me if this
>> is possible, and if it is, then give a clue on how to do this ;)
>>
>> Greets and thanx
>> /Kristoffer
>>


.

Quantcast