A Dimension Attribute with Double DataType converts a zero member to "(blank)"

In one of our SSAS 2005 sp2 cubes, we have a Dimension sourced from an Oracle table, with an Attribute that has a DataType of Double. When we process the Dimension and browse the Attribute, we see the following members:

All

-.01

-.002

.00000000001

.0000000001

Unknown

Notice how its blank where the '0' (zero) member should be. The underlying Oracle table does have '0' (zero) values for this column (you can see them when you explore the data in the DSV). To make things even more confusing,

the Unique_Name for this blank member is: [Dimension].[Attribute].&[0]

its Member_Value is: 0

its Member_Caption is: Null

its Member_Key is: 0

Has anyone seen this behaviour before? If so, how do we fix it?

Thank you.

Hi,

Have you set the NameColumn to look at the same field? And is it a datatype of WChar?

Matt|||

Hi Matt,

Thanks for the reply. Yes, setting the NameColumn to the field was one of the things i tried. The database field is NUMERIC(15,9), the KeyColumn is a datatype of Double and the NameColumn is a datatype of WChar. Even with the NameColumn set to the same field, I still get a blank where the 0 value should be.

-Robbie

64000 dimension members limit?

I get an error populating a dimension that says that there are over 64000
members.
The dimension only has one level.
Is that a limit, bug or am I doing something wrong?
Thanks in advance,
Philip
Analysis Services has a 64K limit on the number of children that any one
parent can have. Since you have only one level, there is only one parent
(i.e. the ALL member); thus you are running into this problem. You can
either add a level which makes sense to your structure, for example taking
the first 3 characters of the customer name and using it as an intermediate
level, or selecting another field which makes sense, e.g. adding State to
the level above Customer, or you can turn on the Analysis Services automatic
grouping level feature where AS will automatically create a level for you.
BTW: In SQL Server 2005 (Yukon), this limitation is lifted.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Philip McComish" <philvmc@.yahoo.com.br> wrote in message
news:u700f4mJFHA.3332@.TK2MSFTNGP15.phx.gbl...
> I get an error populating a dimension that says that there are over 64000
> members.
> The dimension only has one level.
> Is that a limit, bug or am I doing something wrong?
> Thanks in advance,
> Philip
>
|||Dave,
Thanks for the tips. They solved my problem.
Good news about Yukon.
Best regards,
Philip
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> escreveu na mensagem
news:exZFrPpJFHA.2604@.TK2MSFTNGP15.phx.gbl...
> Analysis Services has a 64K limit on the number of children that any one
> parent can have. Since you have only one level, there is only one parent
> (i.e. the ALL member); thus you are running into this problem. You can
> either add a level which makes sense to your structure, for example taking
> the first 3 characters of the customer name and using it as an
> intermediate
> level, or selecting another field which makes sense, e.g. adding State to
> the level above Customer, or you can turn on the Analysis Services
> automatic
> grouping level feature where AS will automatically create a level for you.
> BTW: In SQL Server 2005 (Yukon), this limitation is lifted.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Philip McComish" <philvmc@.yahoo.com.br> wrote in message
> news:u700f4mJFHA.3332@.TK2MSFTNGP15.phx.gbl...
>

64000 dimension members limit?

I get an error populating a dimension that says that there are over 64000
members.
The dimension only has one level.
Is that a limit, bug or am I doing something wrong?
Thanks in advance,
PhilipAnalysis Services has a 64K limit on the number of children that any one
parent can have. Since you have only one level, there is only one parent
(i.e. the ALL member); thus you are running into this problem. You can
either add a level which makes sense to your structure, for example taking
the first 3 characters of the customer name and using it as an intermediate
level, or selecting another field which makes sense, e.g. adding State to
the level above Customer, or you can turn on the Analysis Services automatic
grouping level feature where AS will automatically create a level for you.
BTW: In SQL Server 2005 (Yukon), this limitation is lifted.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Philip McComish" <philvmc@.yahoo.com.br> wrote in message
news:u700f4mJFHA.3332@.TK2MSFTNGP15.phx.gbl...
> I get an error populating a dimension that says that there are over 64000
> members.
> The dimension only has one level.
> Is that a limit, bug or am I doing something wrong?
> Thanks in advance,
> Philip
>|||Dave,
Thanks for the tips. They solved my problem.
Good news about Yukon.
Best regards,
Philip
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> escreveu na mensag
em
news:exZFrPpJFHA.2604@.TK2MSFTNGP15.phx.gbl...
> Analysis Services has a 64K limit on the number of children that any one
> parent can have. Since you have only one level, there is only one parent
> (i.e. the ALL member); thus you are running into this problem. You can
> either add a level which makes sense to your structure, for example taking
> the first 3 characters of the customer name and using it as an
> intermediate
> level, or selecting another field which makes sense, e.g. adding State to
> the level above Customer, or you can turn on the Analysis Services
> automatic
> grouping level feature where AS will automatically create a level for you.
> BTW: In SQL Server 2005 (Yukon), this limitation is lifted.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Philip McComish" <philvmc@.yahoo.com.br> wrote in message
> news:u700f4mJFHA.3332@.TK2MSFTNGP15.phx.gbl...
>