Unknown Members

[Database Administrator]

Hello everyone,

I am using Microsoft Dynamics GP Analysis Services on SQL Server 2005. I am using Microsoft Office Excel Add-in for SQL Server Analysis Services for fetch data. The problem I am facing is that besides real data it is also showing Unknown as an additional member in almost every dimension. Additionally, sometimes it is showing the whole amount against Unknown members instead of individual member i.e. instead of showing Sales for each customer it is showing whole sale amount against 'Unknown'.

Any help will be highly appeciated

Thanks and regards

Abu Owias

[Database Administrator]

It's becuase the dimension key in the fact table do not exist in the
dimension table and the cube processing is done with the option of
converting it to Unknown.

Ohjoo

"Abu Owais" wrote in message
news:eJx1QOXPJHA.2316@TK2MSFTNGP03.phx.gbl...
Hello everyone,

I am using Microsoft Dynamics GP Analysis Services on SQL Server 2005. I am
using Microsoft Office Excel Add-in for SQL Server Analysis Services for
fetch data. The problem I am facing is that besides real data it is also
showing Unknown as an additional member in almost every dimension.
Additionally, sometimes it is showing the whole amount against Unknown
members instead of individual member i.e. instead of showing Sales for each
customer it is showing whole sale amount against 'Unknown'.

Any help will be highly appeciated

Thanks and regards

Abu Owias

[Database Administrator]

Hi Ohjoo, thanks for your reply. Can you let me know as to how can I stop
this. A resource website referral will also work.

Thanks again

Abu Owais

"Ohjoo Kwon" wrote in message
news:%234J4b3aPJHA.4608@TK2MSFTNGP06.phx.gbl...
> It's becuase the dimension key in the fact table do not exist in the
> dimension table and the cube processing is done with the option of
> converting it to Unknown.
>
> Ohjoo
>
> "Abu Owais" wrote in message
> news:eJx1QOXPJHA.2316@TK2MSFTNGP03.phx.gbl...
> Hello everyone,
>
> I am using Microsoft Dynamics GP Analysis Services on SQL Server 2005. I
> am using Microsoft Office Excel Add-in for SQL Server Analysis Services
> for fetch data. The problem I am facing is that besides real data it is
> also showing Unknown as an additional member in almost every dimension.
> Additionally, sometimes it is showing the whole amount against Unknown
> members instead of individual member i.e. instead of showing Sales for
> each customer it is showing whole sale amount against 'Unknown'.
>
> Any help will be highly appeciated
>
> Thanks and regards
>
> Abu Owias
>

[Database Administrator]

It looks like that there are some referential integrity violations between
dimension and fact tables.
First of all, every dimension key instance in the fact table has to appear
in the dimension table.
Otherwise, cube processing is failed if you do not use option of ignore
dimension key errors.

If you did not set any options related to Unknown Member, probably it was
set during cube processing.
In BIDS, right click your cube in the solution explorer and click process
menu.
Click Change Settings buttion at the Process Cube dialog box and click
Dimension key errors tab.
You can see the Key error action of "Covert to unkown" under "Use custom
error configuration".

To remove Unknown Member, go to the dimension editor of the dimension and
click the dimension
in the Attributes pane of Dimension Structure tab.
You can set UnknownMember property to None in the property pane.
But I wish you remember that you should clean your data first.

Ohjoo


"Abu Owais" wrote in message
news:37DD8BD7-78E5-4D94-9333-E661256895B0@microsoft.com...
> Hi Ohjoo, thanks for your reply. Can you let me know as to how can I stop
> this. A resource website referral will also work.
>
> Thanks again
>
> Abu Owais
>
> "Ohjoo Kwon" wrote in message
> news:%234J4b3aPJHA.4608@TK2MSFTNGP06.phx.gbl...
>> It's becuase the dimension key in the fact table do not exist in the
>> dimension table and the cube processing is done with the option of
>> converting it to Unknown.
>>
>> Ohjoo
>>
>> "Abu Owais" wrote in message
>> news:eJx1QOXPJHA.2316@TK2MSFTNGP03.phx.gbl...
>> Hello everyone,
>>
>> I am using Microsoft Dynamics GP Analysis Services on SQL Server 2005. I
>> am using Microsoft Office Excel Add-in for SQL Server Analysis Services
>> for fetch data. The problem I am facing is that besides real data it is
>> also showing Unknown as an additional member in almost every dimension.
>> Additionally, sometimes it is showing the whole amount against Unknown
>> members instead of individual member i.e. instead of showing Sales for
>> each customer it is showing whole sale amount against 'Unknown'.
>>
>> Any help will be highly appeciated
>>
>> Thanks and regards
>>
>> Abu Owias
>>
>