j121
asked on
SSAS 2008 Processing NULL attributes
Hi,
I have a dimension with around 200 attributes that we require all for reporting purposes.
Apart from the key and name columns the other 198 columns can be null.
The problem I am facing is that the dimension will not process unless I set the Error Configuration on the dimension to allow null processing of attributes.
Is this the best practice or in the SQL view on top of the table have something like
E.g
CREATE VIEW AS dbo.vwTableA
SELECT
Key
,Name
,Column2 = ISNULL(Column2, ‘ ‘)
,Column3 = ISNULL (Column3, ‘ ‘)
.
.
.
,Column200 = ISNULL (Column200, ‘ ‘)
FROM TABLE A
Thank you
I have a dimension with around 200 attributes that we require all for reporting purposes.
Apart from the key and name columns the other 198 columns can be null.
The problem I am facing is that the dimension will not process unless I set the Error Configuration on the dimension to allow null processing of attributes.
Is this the best practice or in the SQL view on top of the table have something like
E.g
CREATE VIEW AS dbo.vwTableA
SELECT
Key
,Name
,Column2 = ISNULL(Column2, ‘ ‘)
,Column3 = ISNULL (Column3, ‘ ‘)
.
.
.
,Column200 = ISNULL (Column200, ‘ ‘)
FROM TABLE A
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I hope you win anyhow.