Unknown dimension member

Category: sql server analysisservices

Question

Ramesh x on Mon, 06 May 2013 22:03:06


Hi,

Some Id values are not existing in dimension but they are existing in  dimension.

Is there way that can be made known dimension member ?

Thanks,

Ramesh

Replies

Girija Beuria on Mon, 06 May 2013 22:51:21


Hi Ramesh,

Can you please be more specific. What do you mean when you say :

"Some Id values are not existing in dimension but they are existing in  dimension. "

- Girija

Ramesh x on Tue, 07 May 2013 00:00:38


Hi,

sorry...

Some Id values are not existing in dimension but they are existing in  fact table.

Is there way that can be made unknown dimension member ?

Thanks,

Ramesh

Girija Beuria on Tue, 07 May 2013 00:29:41


Yes,

In the process window (Cube Right click --> Process --> Windows opens)

Click Change Settings --> Go to tab Dimension key errors .

Select the option "Use Cusom Error Configuration"

Image shown below.

- Girija

Elvis Long on Thu, 09 May 2013 02:34:13


Hi,

sorry...

Some Id values are not existing in dimension but they are existing in  fact table.

Is there way that can be made unknown dimension member ?

Thanks,

Ramesh

Hi Ramesh,

The following aritcle can help you to define the Unknown member:
Defining the Unknown Member and Null Processing Properties: http://technet.microsoft.com/en-us/library/ms170707(v=sql.110).aspx

Regards,