Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Analysis Services

Calculated Measure will not deploy

I have a calculated measure which simply tries to generate a Margin Percentage. This is very simply one Measure divided by another. The problem is that when I try to deploy this measure with a Parent Hierarchy of measures it will not deploy I get the error

Errors and Warnings from Response
MdxScript(OPWDW) (7, 8) The 'Measures' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.

Strangly I have managed to get it to deploy once but then the build fails with the same error. I am not sure why this happens as I have done nothing different from what I would normally do and the Measures dimension does only have one hierarchy.

[707 byte] By [sax] at [2007-12-24]
«« How do i insert several records into SQLserver (2005)?
»» using of template class gives error,why?
# 1
Just out of interest my colegue is also having the same problem with a different cube the only difference between this and what we have done in the past is that we are using SP1 of sql 2005 does this change the requirements for our MDX query I am just dragging two measures on and sticking a / between them
sax at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
# 2

Found the answer

Change

CURRENTCUBE.[MEASURES]

to

CURRENTCUBE.[Measures]

sax at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
# 3
Hi Sax,
I tried to changed it but it still same error. How you can solve this error.
Rgds.,
Cherming at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
# 4

When I changed the case this worked for me (maybe try all lowercase)

Also make sure you have SP installed and all 5 hotfixes applied otherwise this seems to cause a problem

Cheers

sax at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
# 5
Hi Sax,
After I had to fix SP and did it again, it work.
Thank for your information.
Cherming at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
SQL Server
SQL Server Analysis Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified