Unknown member question

[Database Administrator]

Hello!

As I understand the "unknown member" means that the dimension key is not
found in the fact table.

In my case, the dimension table IS the fact table.

Does anyone know why is the unknown member represented in my dimension?

David

[Database Administrator]

The "unknown member" means that the dimension key instance in the fact table
is not found in the dimension table.
In that case, cube processing is failed due to dimension key errors.
However, cube processing can be succeeded with the option of ignoring the
errors and converting it to Unknown Member.
As a result, the unknown member will appear.

You can hide or remove Unknown Member through Unknown Member property of
dimension at the dimensin editor.

Ohjoo

"David" wrote in message
news:6610180B-CCC7-4701-81E9-DE18958BC9B8@microsoft.com...
> Hello!
>
> As I understand the "unknown member" means that the dimension key is not
> found in the fact table.
>
> In my case, the dimension table IS the fact table.
>
> Does anyone know why is the unknown member represented in my dimension?
>
> David

[Database Administrator]

First Ohjoo, thank you for answering I hope MS awards your time-investment
in these newsgroups!

Anyhow - my dimension has (Default) errorconfiguration and I abort
processing on any failures (at least that is what I think I do).

I understand what youre saying but Im not sure why this is happening for me
or how I can find out more in order to track down this unknown-member.

The dimension key is the same as the key for the measuregroup built on this
table.

Regards, David

"Ohjoo Kwon" wrote in message
news:uuH9AjCQJHA.576@TK2MSFTNGP04.phx.gbl...
> The "unknown member" means that the dimension key instance in the fact
> table is not found in the dimension table.
> In that case, cube processing is failed due to dimension key errors.
> However, cube processing can be succeeded with the option of ignoring the
> errors and converting it to Unknown Member.
> As a result, the unknown member will appear.
>
> You can hide or remove Unknown Member through Unknown Member property of
> dimension at the dimensin editor.
>
> Ohjoo
>
> "David" wrote in message
> news:6610180B-CCC7-4701-81E9-DE18958BC9B8@microsoft.com...
>> Hello!
>>
>> As I understand the "unknown member" means that the dimension key is not
>> found in the fact table.
>>
>> In my case, the dimension table IS the fact table.
>>
>> Does anyone know why is the unknown member represented in my dimension?
>>
>> David
>
>

[Database Administrator]

It's true that dimension key errors should not occur because the dimension
table is fact table itself.

First of all, all dimension have a Unknown Member by default.
The member can be visible or hidden through setting the related properties.

Here, I wonder you mean that Unknown Member is just seen or it also contains
some value.
For the former case, it will be OK by setting invisible. The latter case
means there are some dimension Key errors anyway.

If the Unknown Member contains some value, access the cube through Excel and
double click a data cell for the member and
Excel shows the detailed records on the other sheet which cause dimension
key errors.

Ohjoo

"David" wrote in message
news:303E22C8-474F-49F5-99A3-9FFE82191D16@microsoft.com...
> First Ohjoo, thank you for answering I hope MS awards your time-investment
> in these newsgroups!
>
> Anyhow - my dimension has (Default) errorconfiguration and I abort
> processing on any failures (at least that is what I think I do).
>
> I understand what youre saying but Im not sure why this is happening for
> me or how I can find out more in order to track down this unknown-member.
>
> The dimension key is the same as the key for the measuregroup built on
> this table.
>
> Regards, David
>
> "Ohjoo Kwon" wrote in message
> news:uuH9AjCQJHA.576@TK2MSFTNGP04.phx.gbl...
>> The "unknown member" means that the dimension key instance in the fact
>> table is not found in the dimension table.
>> In that case, cube processing is failed due to dimension key errors.
>> However, cube processing can be succeeded with the option of ignoring the
>> errors and converting it to Unknown Member.
>> As a result, the unknown member will appear.
>>
>> You can hide or remove Unknown Member through Unknown Member property of
>> dimension at the dimensin editor.
>>
>> Ohjoo
>>
>> "David" wrote in message
>> news:6610180B-CCC7-4701-81E9-DE18958BC9B8@microsoft.com...
>>> Hello!
>>>
>>> As I understand the "unknown member" means that the dimension key is not
>>> found in the fact table.
>>>
>>> In my case, the dimension table IS the fact table.
>>>
>>> Does anyone know why is the unknown member represented in my dimension?
>>>
>>> David
>>
>>
>

[Database Administrator]

Allright, used Excel to check for records causing dimension errors and it
showed nothing.

I guess It's just included by default , I will hide it.

Thank's a lot for helping!

David


"Ohjoo Kwon" wrote in message
news:OhSErKyQJHA.4504@TK2MSFTNGP02.phx.gbl...
> It's true that dimension key errors should not occur because the dimension
> table is fact table itself.
>
> First of all, all dimension have a Unknown Member by default.
> The member can be visible or hidden through setting the related
> properties.
>
> Here, I wonder you mean that Unknown Member is just seen or it also
> contains some value.
> For the former case, it will be OK by setting invisible. The latter case
> means there are some dimension Key errors anyway.
>
> If the Unknown Member contains some value, access the cube through Excel
> and double click a data cell for the member and
> Excel shows the detailed records on the other sheet which cause dimension
> key errors.
>
> Ohjoo
>
> "David" wrote in message
> news:303E22C8-474F-49F5-99A3-9FFE82191D16@microsoft.com...
>> First Ohjoo, thank you for answering I hope MS awards your
>> time-investment in these newsgroups!
>>
>> Anyhow - my dimension has (Default) errorconfiguration and I abort
>> processing on any failures (at least that is what I think I do).
>>
>> I understand what youre saying but Im not sure why this is happening for
>> me or how I can find out more in order to track down this unknown-member.
>>
>> The dimension key is the same as the key for the measuregroup built on
>> this table.
>>
>> Regards, David
>>
>> "Ohjoo Kwon" wrote in message
>> news:uuH9AjCQJHA.576@TK2MSFTNGP04.phx.gbl...
>>> The "unknown member" means that the dimension key instance in the fact
>>> table is not found in the dimension table.
>>> In that case, cube processing is failed due to dimension key errors.
>>> However, cube processing can be succeeded with the option of ignoring
>>> the errors and converting it to Unknown Member.
>>> As a result, the unknown member will appear.
>>>
>>> You can hide or remove Unknown Member through Unknown Member property of
>>> dimension at the dimensin editor.
>>>
>>> Ohjoo
>>>
>>> "David" wrote in message
>>> news:6610180B-CCC7-4701-81E9-DE18958BC9B8@microsoft.com...
>>>> Hello!
>>>>
>>>> As I understand the "unknown member" means that the dimension key is
>>>> not found in the fact table.
>>>>
>>>> In my case, the dimension table IS the fact table.
>>>>
>>>> Does anyone know why is the unknown member represented in my dimension?
>>>>
>>>> David
>>>
>>>
>>
>
>