I have a cube with product dimension (with attributes product id, name, desc, version and phase)
And a freeze dimension which contains version and desc as attributes.
I want to retrieve the product details (specifically the phase, which might change in different versions) based on the version. But when I am trying to do that, I am only able to get one record/row output, rather than multiple records per version with the phase change.
For example: for a product id : 101 Version : 0 If the phase is : initial And for version : 1 Phase is : packed
I need my resulting report to show 101, 0, initial 101, 1, packed
What I am able to see is, 101,0, initial 101,1, packed
Hope this makes sense!