Web intelligence XI 3.1 Bar Chart

[former_member283957]

Dear all,

I want to develop a bar chart  which display data in bar horizontally using Web intelligence XI 3.1

Let me know how to sort the values of the X AXIS using as reference the values of the Y axis

Thanks in advance.

Antonio

[arijit_das · Accepted solution]

1. Drag a Horizontal Grouped Bar chart into the report.

2. Drag dimension and measure objects into proper place into the chart in view structure mode.

3. Select the measure and apply sort as required if you want to sort along x-axis.

4. Select the dimension and apply sort as required if you want to sort along y-axis.

5. Click on View Results to view the chart.

[former_member283957 · Accepted solution]

Dear Arijit,

Thank you for your answer but I have tried to do the same as you wrote me but I cannot see the result as I want. Please see the table besides the Bar Chart , you can see that the first column (Dimension) is sorted using as reference the second column ( measure). I would like to the same with the Bar Chart, to sort the values of the X AXIS (Dimension)  using as reference the values of the Y axis (Measure)

[arijit_das · Accepted solution]

go to view structure mode. remove sort from the dimension object in the chart. apply sort only on the measure.

[former_member283957 · Accepted solution]

Hi Arijit,

It works. Thank very much!

Kind Regards.

Antonio Astudillo

[former_member283957 · Accepted solution]

Dear Arijit,

Let me ask you another issue related to the Bar Chart.

As you can see in the Bar Chart , the measure for example 2,109,093 is displayed in the center of the Bar but I would like to displayed it out of the Bar , near to the Bar.

Let me know please how to solve it.

Kind Regards.

Antonio

[arijit_das · Accepted solution]

BO XI3.1 WebI has no standard feature to change the position of the data label. By default it will be in the middle of each bar only.

[former_member283957 · Accepted solution]

Dear Arijit,

Please I have attached two snapshots . In one of them I log into Web intelligence rich client with a user as administrator but in the another snapshot I log into Web intelligence rich client with a user as BOISIV without  rights as administrator.

As BOISIV I cannot surf through the hierarchy. Let me know please how to change the permissions of BOISIV in  order to surf through the hierarchy.

[arijit_das · Accepted solution]

As you can see, the Explorar option is disabled in case of BOISIV user. This means BOISIV does not have access for drill-down feature.

This right can be assigned from CMC. Login to CMC as administrator and navigate to Applications > Web Intelligence. There in Manage User Security option, you can assign drill-down rights to a particular user/group. First check which right is assigned to the mentioned user. then you can modify that according to your requirement.

Please refer to the admin guide for detail steps.

http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_bip_admin_en.pdf   -Page 1007

[former_member283957 · Accepted solution]

Hi Arijit,

I want to drill down in the report as you can see in the snapshots and I want to put a text into the cell of the column named "Distritos de Madrid", This column is linked with the object dimension [distritos de madrid] .

How to put a text in this cell that is blank NO DATA ? , the text is "No hay distritos" .

I want to continue drill down after putting the text "No hay distritos" into the cell "Distritos de Madrid"

Thank you in advance.

Antonio

[arijit_das · Accepted solution]

As the object is being used in drill-down, you can not use a report level formula. You have to modify the object in the universe and apply the logic there. The syntax is dependent on the database you are using as backend.

[former_member283957 · Accepted solution]

Hi Arijit,

I want to use a MASK for numbers in the reports.

I want to display numbers as  "1.397,65"      65  are decimals.
I would like to use the "comma"  for decimals instead of  "thousands"

Which mask must I use ?

Thanks in advance.

Antonio

[arijit_das · Accepted solution]

This can be done by changing the preferred viewing locale to German. If you are using rich client, change it as shown from Tools > Options:

From Document Properties, check Permanent Regional Formatting.

Then format the numbers in your report.

Regards

[former_member283957 · Accepted solution]

Hi Arijit,

I do not know how to split this bar chart below in two bar charts. As you can see the bar chart is also a table with two colums , I want to split the second column of the table "Total expedientes" in two columns of two tables , one table has the half with maximun values and the second table has the rest of the values.

Once I split the first table in two tables I want to display the two new bar charts related with the two new tables. How can I split the bar chart in two bar charts ? One has the half with maximun values and the second bar chart has the rest of the values.

Thanks in advanced.

Antonio

[arijit_das · Accepted solution]

if the no of rows is constant in the initial table then you can achieve this using sorting and ranking.

Otherwise, as an alternative, you can sort the chart according to the values and use a slider in input control to show top n / bottom n.

[former_member283957 · Accepted solution]

Hi Arijit,

I have written below a JSP page in order to log in into "Infoview"  without introducing user and password for any user , Not only the "gues" t user.

The JSP page is not working. Could you fix it ? Please.

Thanks in advance.

Antonio

SSO – BY PASS INFOVIEW

Use this code to create your own SSO to InfoView for unsupported authentication systems.

IEnterpriseSession enterpriseSession = CrystalEnterprise.getSessionMgr().logon("<your

username>", "<your password>", "<your Central Management Server name>", "<your

authentication type>");

String logonToken = enterpriseSession.getLogonTokenMgr().createLogonToken();

/* URL to the InfoView logon page - Ensure that the URL to the Java InfoView's logon

page is correct. */

String infoViewURL =

"http://myServer:8080InfoViewApp/logon/start.do?ivsLogonToken=" + logonToken;

/* URL request */

response.sendRedirect(infoViewURL);

JSP PAGE ,  not works.

　

<%--

- Version: $Revision: #1 $

- Last Modified Date: $Date: 2003/05/16 $

- Author: $Business Objects, Inc. 895 Emerson St., Palo Alto, California, USA 94301. $

-

- @(#)

-

--%>

<%@ page contentType="text/html; charset=UTF-8" %>

<%@ page import="com.crystaldecisions.enterprise.ocaframework.ServiceNames" %>

<%@ page import="com.crystaldecisions.sdk.exception.SDKException" %>

<%@ page import="com.crystaldecisions.sdk.framework.CrystalEnterprise" %>

<%@ page import="com.crystaldecisions.sdk.framework.IEnterpriseSession" %>

<%@ page import="com.crystaldecisions.sdk.framework.ISessionMgr" %>

<%@ page import="com.crystaldecisions.sdk.occa.infostore.IInfoStore" %>

<%@ page import="com.crystaldecisions.sdk.occa.managedreports.*" %>

<%@ page import="com.crystaldecisions.sdk.occa.security.ILogonTokenMgr" %>

<%@ page import="javax.servlet.http.Cookie" %>

<%@ page import="java.net.URLEncoder" %>

out.println("Al principio");

<%

// Set the expiration header.

response.setHeader( "Expire", "0" );

%>

<link REL=STYLESHEET TYPE="text/css" HREF="cmi.css">

<html>

<body>

<%

// Constants

// final String CMS = "MAQUINA:6400";

// final String USERNAME = "ANONIMO";

// final String PASSWORD = "";

// final String AUTH = "secEnterprise";

// Retrieve the parameters that the user entered into the logon fields.

// String url = "/OpenDocument/opendoc/openDocument.jsp?";

String docId = request.getParameter("docId");

IEnterpriseSession enterpriseSession = null;

ISessionMgr sessionMgr = CrystalEnterprise.getSessionMgr();

Exception failure = null;

boolean loggedIn = true;

out.println("Antes del if");

// If no session already exists, logon using the specified parameters.

if (enterpriseSession == null)

{

try

{

// Attempt logon. Create an Enterprise session manager object.

ISessionMgr sm = CrystalEnterprise.getSessionMgr();

// Log on to BusinessObjects Enterprise

// enterpriseSession = sm.logon(USERNAME, PASSWORD, CMS, AUTH);

enterpriseSession = CrystalEnterprise.getSessionMgr().logon("EXAMEN", "EXAMEN", "MAQUINA", "secEnterprise");

 

}

catch (Exception error)

{

loggedIn = false;

failure = error;

}

out.println("Despues del catch");

// Store the IEnterpriseSession object in the session.

session.setAttribute("EnterpriseSession", enterpriseSession);

// Create the IInfoStore object.

IInfoStore iStore = (IInfoStore) enterpriseSession.getService("InfoStore", ServiceNames.OCA_I_IINFO_STORE);

// Store the IInfoStore object in the session using the

// helper functions.

session.setAttribute("InfoStore", iStore);

// Retrieve the logon token manager.

ILogonTokenMgr logonTokenMgr = enterpriseSession.getLogonTokenMgr();

// Retrieve a logon token and store it in the user's cookie

// file for use later.

String logonToken = enterpriseSession.getLogonTokenMgr().createLogonToken();

String tokenEncode = URLEncoder.encode(logonTokenMgr.createLogonToken("",10, 100)); //TODO definir constantes

Cookie cookie = new Cookie("LogonToken", tokenEncode );

response.addCookie(cookie);

// url += "iDocID=" + docId + "&token=" + tokenEncode;

// String url = "http://MAQUINA:8080/InfoViewApp/logon/start.do?ivsLogonToken=" + tokenEncode;

String url = "http://MAQUINA:8080/InfoViewApp/logon/start.do?ivsLogonToken=" + logonToken;

response.sendRedirect (url);

 

}

%>

</body>

</html>

　

[arijit_das · Accepted solution]

A few questions:

1. Are you going to create a logon page for InfoView with hardcoded username and password ?

2. In which location in the server did you place the jsp file ?

3. How are you accessing the jsp file ?

** Please note that if you use hardcoded userid and password to achieve SSO, then this is not a good practice in terms of security.

-Anyone having the log-in page link can access the system.

-To setup different data and access level security restrictions for different users is not possible as all users actually use same userid.

-Auditing will log all activities for one single user.

Better to use other SSO techniques like Windows Active Directory with third party tools like kerberos or siteminder.

[former_member188911 · Accepted solution]

Hi Antonio,

you already opened a thread with the same question, I moved it to the Java SDK discussions 

Please note that this method is not supported, you will probably get more details in the other thread

Thanks

Best regards,

Simone Caneparo

SCN Discussions Moderator