OLAP Cube MDX calculation returns 0 when value is set
I have a dimension ship that has speedinKM but when i look in the cube browser the calculation does not return the expected value. The data from the dimension shows up in the cube browser but returns 0 in the calculation. does anyone know what the problem can be?
//[travel time]
[D Ship].[Speed In Km H] + 10
](https://i.sstatic.net/v9JyJ.png)
](https://i.sstatic.net/LRSFa.png)
i tried rebuilding the cube and reloading the data from the data warehouse but its not working?
Solution
Because you are trying to extract the member's value from the [D Ship] dimension I think being more specific about this extraction might help:
[D Ship].[Speed In Km H].CURRENTMEMBER.MemberValue + 10
- Is there a healthy way to bridge a link between a fact-dimension, where their relationship is only partial?
- Gatsby MDX not rendering properly
- MS SSAS MDX Ensure UI (E.g. Excel) shows the latest member of a dimension on refresh
- MDX dynamic year in filter
- MDX function to find if a Member IsMemberOf a set
- How to create a new dimension inside Cube with MDX. I would like it to be as a concatenation of existing two dimensions
- Aggregating Members calculated with IIF / CurrentMember conditions
- Is there any way to use LINQ for MDX queries?
- MDX for concatenated dimension level based on result of another calculated member in cube design
- Gatsby 5 - get fileAbsolutePath for a node
- VS Code MDX Extension shows error for footnotes and default export
- How to take MDX Query from SSAS Multidimensional Cube and Use To Build Power BI Report?
- How to join two cubes on a shared dimension using MDX?
- Storybook 7 throws typeerror for file named 'name.stories.mdx' but if I rename it to 'name.stories.anything.mdx' it works with the exact same content
- How to include multiple items in "SAP VARIABLES"?
- CUBESET() function in Excel with Multiple criteria
- Docusaurus: Markdown links not working with .mdx files for inter-page linking
- Passing a parameter into an MDX Query using Power Query in Excel
- What is MDX and what is its use in SAP BPC
- How to use MDX Functions in SAP dreamweaver's MDXTEST
- Updating cube (writeback) via MDX on SAP BW
- MDX filtering by member property on SAP BW
- OLAP Cube MDX calculation returns 0 when value is set
- Using accumulative sum on ordered MDX query
- MDX Query with parameters with multiples values and null value
- How to insert a string literal as a new column in an mdx query
- How do I go about restoring an SSAS 2000 .CAB file using 2008 tools?
- MS SSAS - Need to return a measure in a calculated member based on a tuple set and a max ofunderlying ID
- UNION ALL of 2 MDX queries (within data cube)
- MDX Calculated Member filter using attribute not working