I am using the Essbase Connector for the first time. I have connected, but like many have reported, I cannot see any measures. Therefore, I cannot build the query. I saw a post that said that the items need to be classified as "Accounts Dimensions" to show up in the Measures. I do not think that altering the cube is an option for me.
Is there a workaround for this - other than attempting to write all of the queries manually? I was able to build a simple query just to see if it work, but that will be an extreme pain to write to get all of the necessary data pulled in.