Setup Pivot4J Analytics to Consume SSAS Multidimensional Models

-
  • Pivot4J Analytics is a recent replacement of JPivot OLAP Browser. Pivot4J Analytics can be used to consume SSAS Multidimensional Models. Setting up Pivot4J Analytics is very simple and should take less than 40 minutes.
  • These are the steps:
    A. Configure HTTP access for your SSAS server
    B. Install Recent JDK
    Download recent JDK from https://jdk8.java.net/download.html
    And perform default install.
    C. Setup Environment Variable JAVA_HOME
    • Open File Explorer
    • Right Click on Computer and click on properties
    • Click on Advanced Systems Setting
    • Click on Advanced tab
    • Click on Environment Variables
    • Create a new system variable
    • Enter the Variable name as JAVA_HOME and the value to your jdk bin path (In my case it is C:\Program Files\Java\jdk1.8.0\bin)
    • NOTE Make sure u start with ; in the Value so that it doesn’t corrupt the other environment variables which is already set.
    • Click OK twice to close open windows
    • Restart you computer
    D. Install Tomcat 6.0
    E. Install and configure Pivot4J Analytics
    • Download Pivot4J Analytics Web Archive (.war) file from http://mysticfall.github.io/pivot4j/download.html
    • Copy war file to C:\tomcat\webapps folder
    • Restart Apache Tomcat 6.0 tomcat6 service by right clicking on it
    • Stop Apache Tomcat 6.0 tomcat6 service
    • Open WordPad in Administrative mode
    • Open file pivot4j-config.xml from folder C:\tomcat\webapps\pivot4j-analytics-0.8\WEB-INF
    • Define SSAS data source as shown here:
    <datasource>
    <name>Sample</name>
    <description>Sample data source(XMLA).</description>
    <connection-info><url>jdbc:xmla:</url>
    <driverClass>org.olap4j.driver.xmla.XmlaOlap4jDriver</driverClass>
    <user>XXXXX\XXXXXXX</user>
    <password>*******</password>
    <properties><property name=”Server”>http://localhost/OLAP/msmdpump.dll</property>
    <property name=”Catalog”>XXXXXXXX</property>
    </properties>
    </connection-info>
    </datasource>

Comments

Post a Comment

Popular posts from this blog

SSRS Reports Rotate Text Or Split Alphabet Per Line

-
Image
Few days ago my client requested a report, which required rotation of text and alphabet by 45 degree. Expected output was something Like this: Many of you may know that you can rotate a text in textbox by setting WritingMode to "tb-rl", which will rotate the text and it will look something like this: In order to rotate text at desired angle do following: (1) create an image with desired text (2) rotate that image (3) import it to the image box in report Add System.Drawing to the references by going to the Report Properties -> References. for step1 use following function: Function CreateImage(ByVal sImageText As String, ByVal FontType As String, ByVal FontSize As Integer) As System.Drawing.Bitmap 'Create an image from scratch Dim bmpImage As New Drawing.Bitmap(1, 1) Dim iWidth As Integer = 0 Dim iHeight As Integer = 0 'Create the Font object for the image text drawing. Dim MyFont As New Drawing.Font(FontType, FontSize, System.Drawing.FontStyle.Bold, System.Drawing.G...
Read more

Opinionated Microservices Framework Lagom

-
Lagom is a Swedish word meaning “just the right amount”. Microservices have often been categorised as small services. However, Lightbend wants to emphasize that finding the right boundaries between services, aligning them with bounded contexts, business capabilities, and isolation requirements are the most important aspects when architecting a microservice-based system. Therefore, it fits very well in a Domain-Driven Design focused mindset. Following this will help in building a scalable and resilient system that is easy to deploy and manage. According to Lightbend the focus should not be on how small the services are, but instead they should be just the right size , “Lagom” size services. Lagom, being an opinionated framework, provides a “golden path” from which the developer can deviate if necessary. Being based on the reactive principles as defined in the Reactive Manifesto , Lagom provides the developer a guard-railed approach with good defaults while also allowing to deviate if...
Read more

Recommender systems using MLlib

-
Collaborative filtering is commonly used for recommender systems. These techniques aim to fill in the missing entries of a user-item association matrix. spark.ml currently supports model-based collaborative filtering, in which users and products are described by a small set of latent factors that can be used to predict missing entries. spark.ml uses the alternating least squares (ALS) algorithm to learn these latent factors. The implementation in spark.ml has the following parameters: numBlocks is the number of blocks the users and items will be partitioned into in order to parallelize computation (defaults to 10). rank is the number of latent factors in the model (defaults to 10). maxIter is the maximum number of iterations to run (defaults to 10). regParam specifies the regularization parameter in ALS (defaults to 1.0). implicitPrefs specifies whether to use the explicit feedback ALS variant or one adapted for implicit feedback data (defaults to false...
Read more