Menu
Working with SSAS 2008 in an environment with mostly Mac desktops. Use DbVisualizer and Aqua Data Studio for writing relational queries, but need a native desktop app to write MDX queries and view results from OLAP sources.
VMWare / Parallels is not the approach we need, and RDP / Terminal Services is used in some situations. Web based interfaces are OK for endusers, but BI developers would prefer something more convenient.
Google searches have not returned too many useful hits.
Can anyone recommend a native / Java desktop app for browsing and querying OLAP sources?
546
In Excel, you can connect to OLAP cubes (often called multidimensional cubes) and create interesting and compelling report pages with Power View. To connect to a multidimensional data source, from the ribbon select Data > Get External Data > From Other Sources > From Analysis Services.
One of the main methods of accessing the OLAP Cube is using an Excel pivot table. Since pivot tables are more used by the business users, they can leverage the excel features by using the cubes. In the Excel pivot tables, you can use columns as well as rows to select dimensions.
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More... Online Analytical Processing (OLAP) is a technology that is used to organize large business databases and support business intelligence.
Does your OLAP server support XMLA? If yes then have you taken a look at La_Azada or JPivot?
In my opinion (and unfortunately), MS reporting/visualizing tools for OLAP are way more convenient for end users than other open source alternatives.
145
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
