vegaaltair
New Member
- Joined
- Sep 12, 2014
- Messages
- 9
Hi I need help trying to understand an error when using below cube value formula, I have a column of "system" which when using in the formula will make everything error however if I was to use another column to slice by everything works fine, in order to solve this could you give me some reasons why it could possibly be erroring one just this one column? checked the data type and any spaces or errors in the column and still cannot get it to work, the next column of "site" is exactly the format etc and it works perfectly.
Errors
Works
Errors
Excel Formula:
=CUBEMEMBER("ThisWorkbookDataModel","[00 - ALL].[System].&[FINANCE]")
Works
Excel Formula:
=CUBEMEMBER("ThisWorkbookDataModel","[00 - ATB ALL].[Site].&[NORTH]")