Tagged with OLAP - Visokio Forums http://forums.visokio.com/discussions/tagged/OLAP/feed.rss Mon, 30 Oct 17 12:24:32 -0400 Tagged with OLAP - 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]]>
Sources: OLAP cubes - Essbase access? http://forums.visokio.com/discussion/1595/sources-olap-cubes-essbase-accesss Tue, 12 Jun 2012 09:59:47 -0400 bfromson1 1595@/discussions
Latest Omniscope build is now showing more detailed diagnostic:

Using Essbase version 9.3.1]]>
Sources: OLAP Cubes & Excel PowerPIvot? http://forums.visokio.com/discussion/503/sources-olap-cubes-excel-powerpivots Mon, 15 Nov 2010 16:33:07 -0500 benjamin 503@/discussions
Is it possible to piggy-back off Excel PowerPivot i.e run Omniscope off PowerPivot and thus enabling 1m + rows functionality in Omniscope?]]>
Sources: OLAP - Support for Mondrian with XMLA? http://forums.visokio.com/discussion/1456/sources-olap-support-for-mondrian-with-xmlas Tue, 10 Apr 2012 16:17:50 -0400 haubuchon 1456@/discussions
Rowset 'MDSCHEMA_SETS' does not support property 'Content' (value is 'Data') (also LocaleIdentifier property)

If I use the "Load" Button, I get an error with the MDX:

"TableRenderer requires 0, 1 or 2 dimensional result".

Do you have any plans on supporting Mondrian, or at least an OLAP OLE DB like Simba that correctly supports Mondrian ?

Thank you !]]>
Sources: OLAP cube connections? http://forums.visokio.com/discussion/366/sources-olap-cube-connectionss Fri, 06 Aug 2010 09:52:26 -0400 matt.mec 366@/discussions Matt]]> Sources: Connecting to SAP BW/InfoCube? http://forums.visokio.com/discussion/360/sources-connecting-to-sap-bwinfocubes Fri, 23 Jul 2010 11:15:26 -0400 e300984 360@/discussions Archtecture: OLAP functionality? http://forums.visokio.com/discussion/179/archtecture-olap-functionalitys Wed, 18 Nov 2009 11:10:49 -0500 Kirsten_Tisdale 179@/discussions