November 5, 2015 at 12:29 am
Hi Team,
I am getting #Value! error in excel when i am trying to browse cube from excel. The same values are getting displayed properly when i am performing MDX query from SSMS.
I tried analyze in excel option available in SSDT as well but i am getting same error.
What could be the reason?
Thanks
November 5, 2015 at 7:10 am
This typically happens when there is a division error (i.e. division by zero). If my assumption is correct, you're probably seeing this in a calculated measure and there is a division within the calculation. You will have to deal with the possibility of the denominator being zero.
November 5, 2015 at 7:12 am
This is probably caused by some sort of MDX failure/incompatibility/Excel read error.
The cell that is meant to be showing a value:
1. Is is a calculated measure?
2. Does it have a FORMAT_STRING specified (if it is a calculated member or not).
3. What should it display (a number, a string, a percentage, etc.)?
4. If it is a string value then does it have an excel reserved character (=, &, etc.)?
You really need to provide a little more information to get a good answer 🙂
Edit: Martin and I posted at the same(ish) time. So add what he said to my list of things to check. If that is the issue and you are on 2012 or later then you can use the DIVIDE keyword in your calculation instead of the / operator. In earlier versions you will have to wrap the calculation in an IIF logic.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply