Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I found the solution. Actual column was hidden in the criteria. Once I made it visible it started to show up.
-
Sorry if I was not clear. The select query I am using is actually on Filter of type SQL Expression. Also my Months are coming from Period dimension I am not using text values. But the selection of the Period.Month Filter I want to use is dynamic and hence I am using SQL Expression. Screenshot attached below. I need a way…
-
Yes My source is Essbase version 11.1.2.3.500 and OBIEE 11.1.1.9. Is there a way to see MDX query from OBIEE that is send to Essbase so I can compare? I have used member in selection to hide and it improved retrieval bit. Thanks, Suresh