OLAP Cubes

Charts

Key Features

Create and save views, choosing which dimensions to display on rows and columns
Nominate up to three dimensions from the cube to use as fixed/slicer criteria
Drill down into row and column dimensions and dynamically change values in the fixed dimensions
Color code data based on user-defined criteria (e.g. value is less than 10,000)
Chart the results via Google Charts as either Line, Bar, Horizontal Bar, Pie or Gauge
Sensitive data such as server and user names stored on the device are fully encrypted

17 thoughts on “#SSAS #Android Client #MSSQL”

Hi there, would you perhaps know how to connect to the OLAP Server it says URL but would I be able to put in the IP Address?

Or would I have to configure the OLAP Server for HTTP Access?

Thanks
Gilbert

Reply ↓

Michael Olschimke on August 1, 2012 at 6:53 am said:

Hi Gilbert,

have you tried out http://123.123.123.123 ?

You need to configure HTTP access: http://msdn.microsoft.com/en-us/library/gg492140.aspx

Mike

Reply ↓
- Gilbert Quevauvilliers on August 1, 2012 at 6:54 am said:
  
  Hi there I will give that a try now 🙂
  
  What Username and password must I use?
  
  I would also like to try this in my own environment, that is why the question on how to connect to my local OLAP Server.
  
  Thanks
  Gilbert
  
  Reply ↓
  - Michael Olschimke on August 1, 2012 at 6:58 am said:
    
    Hi Gilbert,
    
    from http://msdn.microsoft.com/en-us/library/gg492140.aspx
    
    When MSMDPUMP connects to Analysis Services, it does so under a Windows user identity. This account will either be the Anonymous account if you configured the virtual directory for anonymous connections, or a Windows user account. The account must have the appropriate data access rights on the Analysis Services server and database.
    
    Regarding your localhost configuration: not sure if the app can connect via wifi (which would be required to access your local IP). Please let me know.
    
    Greetings,
    
    Michael
    
    Reply ↓
    - Gilbert Quevauvilliers on August 1, 2012 at 7:00 am said:
      
      Ok perfect thanks for clarifying this. I have not done this before but I am sure I can get it working to connect to my local server.
      
      Once I have done that and I can connect I will update you with how it works. Thanks for the replies so far.
      
      Gilbert
  - Michael Olschimke on August 8, 2012 at 7:51 am said:
    
    Hi Gilbert,
    
    did you had a chance to try out a Wifi connection to your local cube? Did it work?
    
    Thanks,
    
    Michael
    
    Reply ↓
    - Guavaq on August 8, 2012 at 7:57 am said:
      
      Hi there,
      
      I am still waiting for my security department to allow me access via the Wifi. As soon as I can test it I will let you know
      
      Thanks
      Gilbert
    - Gilbert on September 17, 2012 at 10:34 am said:
      
      Hey, I have been struggling with our Security Department to allow me access via Wi-Fi to our secure servers. I am still trying and as soon as I can get it working I will let you know.
      
      Thanks
      Gilbert

By the way, the URL of the developer is

http://www.analytix.mobi/

However, they don’t have any information online about the tool, just for their Google Analytics Android client.

Reply ↓

Gilbert Quevauvilliers on August 1, 2012 at 8:32 am said:

Cool thanks for all your advice and helping me out!

Thanks
Gilbert

Reply ↓
- Michael Olschimke on August 1, 2012 at 8:33 am said:
  
  Did it work with Wifi?
  
  I have the problem that I only have SSAS at work and the customer is restricting Wifi access.
  
  So I can’t try out.
  
  Thanks,
  
  Michael
  
  Reply ↓
  - Yohan on February 18, 2013 at 10:39 am said:
    
    Hi Micheal,
    
    I need some guidance on creating an android charts using OLAP data sources. Could you please help me out.
    
    Regards,
    Yohan
    
    Reply ↓
    - Michael Olschimke on February 18, 2013 at 2:07 pm said:
      
      Hi Yohan,
      
      have you checked out Cubeware? It’s an OLAP frontend for SQL Server and other OLAP sources. they also have a Android and iPhone app.
      
      Cheers,
      
      Michael
    - Yohan on February 19, 2013 at 3:10 am said:
      
      Hi Michael,
      
      Thanks for the reply. I guess that’s an app , but what i want is to build an android app which support OLAP data sources and build a reporting/charting application. Can you advise ?
      
      Regards,
      Yohan
    - Michael Olschimke on February 20, 2013 at 10:21 pm said:
      
      Hi Yohan,
      
      Android is based on (a special version of) Java. I’m not sure if this will work on Android, but you should check out http://www.olap4j.org/
      
      Please let me know if you’re having success with this or not. I’m definitively interested!
      
      Best,
      
      Mike