Tagged with ssas - Visokio Forums http://forums.visokio.com/discussions/tagged/ssas/feed.rss Mon, 30 Oct 17 12:24:36 -0400 Tagged with ssas - Visokio Forums en-CA SSAS Cubes: support for Data Connector in 3.0? http://forums.visokio.com/discussion/3253/ssas-cubes-support-for-data-connector-in-3.0s Wed, 28 Jun 2017 03:33:25 -0400 AlexD 3253@/discussions
Most people in our organisation will reconcile their work to SSAS Cubes, and we have often needed to make workarounds to report the same data, such as replicating the Cube from the underling Warehouse. This creates heartbreaking duplication of logic and exposes us to the risk of missing out logic built between the Warehouse and Cube.

It would be good to know if SSAS Cubes will be a supported connector in Omniscope 3.0.

Thanks]]>
Sources: Hierarchies in OLAP cube connector http://forums.visokio.com/discussion/3230/sources-hierarchies-in-olap-cube-connector Tue, 25 Apr 2017 09:39:39 -0400 Cheyam 3230@/discussions
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]]>
Sources: Connecting to SSAS tabular model http://forums.visokio.com/discussion/3007/sources-connecting-to-ssas-tabular-model Tue, 29 Sep 2015 09:16:02 -0400 esmith01 3007@/discussions
The error message we’re getting is “no cubes found on the selected OLAP server” – we have a few tabular models deployed on the server and have been able to verify the connection to the cubes in excel, so it seems something isn’t picking them up in Omniscope.
Thanks]]>