We are connecting to one of our companies OLAP cubes and querying data successfully however we are only able to pull the first level of a hierarchy back. There doesn't seem to be any way to get the second or third levels in a hierarchy (i.e. one column returned instead of three).
Is there any way around this or does Omniscope not support this?
Using version 3.0 build 7315 Data manager 1
Thank you, Chey
Screenshots attached of Cube in Excel vs Cube connector in Omni
Thanks for your post. Unfortunately this isn't possible in the OLAP connector in Omniscope desktop. We may develop a new OLAP connector in Omniscope3. Please get in touch with us directly if this is something you need and we can discuss your requirements further.