mdxpentaho
MDX Using Member_Key
I'm trying to write a query which uses order in the Pentaho Schema Workbench program.
A simple query I pulled from Saiku analysis's GUI runs without issue.
Trying to add in an order yields the message "No function matches signature '.Member_Key'"
How would I got about debugging this? All the examples I see online for ordering data use CurrentMember and Member_Key so I'm a little lost.
Solution
I found this page online which shows how to access intrinsic properties through Mondrian MDX.
Instead of [DimTime.CalendarYearMonth].CurrentMember.MEMBER_KEY you write [DimTime.CalendarYearMonth].CurrentMember.Properties("MEMBER_KEY")
- 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