Tuesday, July 22, 2008

Hyperion WebAnalysis Tutorial

You can launch the web analysis studio from Workspace or using the URL http://localhost:19000/WebAnalysis/LogOn.jsp
The left pane consists of two parts. The upper part contains the forlders and the lower part displays the content.
You can open a report clicking on any of the available reports in left lower portion.
Double click on the dimensions will perform the drill down. Also Right click will show the options like drill down and drill up.
For slicing and dicing, you can use keep only or remove only options. Try these options and see the effects.

You can change the chart types also.
You can change the interface in Design mode to do formatting and to create new reports.
As soon as you change the display into design mode, you will see lot of other buttons visible in the toolbar.
To create a new chart point and drag the chart icon to the main window.
A window will open and will ask to place columns, rows and pages. You can apply filters.

Right click on the chat and select properties.
You can change the chart type.
To make a new database connection
Make sure to return back from design mode by simply clicking on the button to the left of design mode button.
From the picture above you can create new document or database connection.
You will have choices of databases type. Click on relational.
Select the database and provide JDBC connect string. The format will automatically come up in the connect string. Simply provide the details and test connection.
To create a new document, select create document.
Provide the connection file name by clicking on browse.
Select the database connection from the list.
Provide the coliumns, rows and pages.
At last provide the layout type.
The report will be created .
By changing the properties, you can make very beautiful and intuitive charts.

I will try to bring more features in my next blog.

11 comments:

Ram said...

Hi,

You're blog is informative.

Query:

1)What are the s/w needs to be downloaded for web analyzer?

2) How to install and Start any configuration required?

I have downloaded
i) Hyperion Reporting and Analysis – System 9 Client Release 9.3.1

Hyperion Web Analysis – system 9 Release 9.3.1

Hyperion Financial Reporting – System 9 Release 9.3.1 Microsoft Windows x86 Installer

2) Hyperion Reporting and Analysis – System 9 Services Release 9.3.1

Hyperion Web Analysis – system 9 Release 9.3.1

Hyperion Financial Reporting – System 9 Release 9.3.1 Microsoft Windows x86 Installer

3) Hyperion Reporting and Analysis – System 9 UI Services Release 9.3.1 Microsoft Windows x86 Installer

Anything else required. If not how to configure and getting started to work on analyzer pls

-Ram

repati said...

Hi,

We are trying to create a new relational connection with an oracle driver but it is saying as "Getting Connection Failed",Please help in solving the issue.

jayanth said...

Hi Manohar,

Will u please tell me how can we launch the web analysis studio from Workspace or using the URL http://localhost:19000/WebAnalysis/LogOn.jsp


Regards
jnth
Jnthchowdary@gmail.com

Krishna said...

Hi Manohar,

I am trying to learn Hyperion web analysis 9.3.1. I was wondering if the installation come with some sample report for getting started and to self learn!??

Regards,
Dmkris

Raj said...

Manohar,
nice blogs, I have question on Web Analysis, how to find the value of the existing data source in an existing Web Analysis report. In Data Object Properties it shows as "ReportDataSrc1" but I could not find a way to which database it is connecting to.
Thanks

anki.hyperion said...

Hi Manohar,
I’m facing a problem in Hyperion Analyzer 7.2 .
I was asked to create a report ass below. Here I have to find the “Pct”. To find Pct we have to divide each count with Total count.
Eg.,Pct for Alford 2008 is percentage of division of 12 with Total count 155,Its 7.745..So,round it off to 8%.

So,here I’m unable create a calculation for this logic because while going to create “Pct” ,I’m only able to see count but not “Total”
So,Can u please help to create a calculation for this logic.

Alford Ferro Ghanem Total
Count Pct Count Pct Count Pct Count Pct
2009 1 1% 0 0% 1 1% 2 1%
2008 12 8% 7 5% 17 11% 36 23%
2007 41 26% 39 25% 37 24% 117 75%
Total 54 35% 46 30% 55 35% 155 100%



Thanks
-Anki

Neil said...

Through this hyperion web analysis we are able to analyze the performance. Thanks for the posting on this topic that would be useful for me.
Web Design Quote

종권 said...

Hi
Can I have a question?(Urgent.)
I want to create an "entity" dimension hierarchy on relational database connection in web analysis?
how to do?
Do not you just answer?
sorry..
have nice day!

Rose said...

My question is on Show/Hide. I have a report with two dimensions on the rows. I am hiding intersections at the parent level that I do not want to show. My question is - how do I hide the children of those members without having to choose them individually. I was hoping that if I chose the parent of a rollup that when the user drilled down, the children of the hidden member would be hidden. This is not happening. If I do a show only, I cannot drill down to the children.

Any help you can provide would be greatly appreciated.

aswartha said...

Hi Ram,

Please can explain me how to create data forms in hyperion Planning.

kanduri said...

i want total information about reporting scripts pls pls pls send as soon as possible




from bharath hyperion developer