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

How to write MDX or DMX stored procedures

-
Learn how to create and execute MDX (Multidimensional Expressions) and DMX (Data Mining Extensions) stored procedures in SQL Server to perform advanced data analysis and business intelligence operations. Introduction to MDX and DMX SQL Server provides rich support for data analysis through its support of MDX and DMX languages. MDX is primarily used for querying and manipulating data in multidimensional databases, typically OLAP cubes. On the other hand, DMX is used for managing and querying data mining models, making it essential for advanced analytics and predictive modeling. In this post, we’ll explore how to write stored procedures that utilize these languages within SQL Server. A stored procedure allows you to automate your queries and can be used to encapsulate MDX or DMX scripts for reusable and efficient data analysis. Creating a Basic MDX Stored Procedure MDX queries are often used for complex rep...
Read more

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

How Leaky ReLU Helps Neural Networks Learn Better

-
When training deep neural networks, choosing the right activation function can make a huge difference. One of the most common choices— ReLU (Rectified Linear Unit) —is popular for its simplicity and speed. But it's not without flaws. Enter: Leaky ReLU — a small tweak that solves a big problem. The Problem with Vanilla ReLU ReLU is defined as: f(x) = max(0, x) Which means: If x > 0 , output is x If x , output is 0 While this works great most of the time, it comes with a major drawback : Dead Neurons Problem If a neuron gets stuck in the negative range, it always outputs 0. That means no gradient, no learning — it's "dead." Over time, a portion of your network can become inactive, especially in deep architectures. How Leaky ReLU Fixes This Leaky ReLU modifies the function like so: f(x) = x if x > 0 f(x) = αx if x This tiny slope for negative values (instead of zero) helps keep the neuron alive and gradients flowing...
Read more