[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Messages posted by: hemgoyal.spw
Forum Index » Profile for hemgoyal.spw » Messages posted by hemgoyal.spw
Author Message
Hi,

When I click multiple times on execute button on an JPivot OLAP doc, error message is shown "concurrent requests and no busy.jsp defined in web.xml"
To show the proper busy page in JPivot, I un-commented the busy.jsp configuration in web.xml.

Now, when I click too fast on an olap document, busy.jsp is shown. After 1 seconds, it refreshes again and redirected to index.jsp.
Is there any configuration or work around so that it can show the olap page with result. (same as when I click on execute button and waiting for loading the page)

Thanks.
Hi,

QBE-Corsstab creates temporary table in reporting DB to improve performance.

Is there any way to disable it.
Or if it can not be disabled, is there any way to use a different DB, other than reporting DB, for temporary table creation.

As per SpagoBI documentation:
"SpagoBIQbeEngine has to be provided with a database connection user with table creation right; if it is not the case, you can disable the temporary table strategy by setting the "enabled" property to false, and this strategy will be substituted by another strategy that uses the SQL inline view construct."

<QBE_TEMPORARY_TABLE enabled="true" prefix="TMPSBIQBE_" suffix="" />

However this flag is not working.

Thanks.
Hi SpagoBI Team

The U.S. Department of Homeland Security urged computer users to disable Oracle Corp's Java software, amplifying security experts' prior warnings to hundreds of millions of consumers and businesses that use it to surf the Web.

Please refer following links for detail

http://www.us-cert.gov/cas/techalerts/TA13-010A.html

http://java.com/en/download/help/disable_browser.xml

http://www.oracle.com/technetwork/topics/security/alert-cve-2013-0422-1896849.html

http://www.nbcnews.com/technology/technolog/us-warns-java-software-security-concerns-escalate-1B7938755

If JAVA is disabled on browser, is there any impact on spagoBI usage/any degradation ?

Is there any other impact on SpagoBI usage because of this alert.

Thanks,
Hemant
Address already in use<null>:8080

Port 8080 is already in use by some other application.

Either stop that application or change the SpagoBI port.

Thanks
KPI value gauge(dial meter) shows 0,20,40,60,80..tick values. If a KPI has threshold range of 0(lowest) and 1(highest), tick values are not shown.

Following changes can be done to fix the issue:

File: SpagoBI-Server-3.4\webapps\SpagoBI\js\src\ext\sbi\kpi\GUI\KpiGUIDetail.js
line: 165
Current line: tickInterval: 20,
New Line: tickInterval: this.maxChartValue/4,
or
tickInterval: this.maxChartValue/5,
Hi Antonella,

I wanted to use SpagoBI DB authentication, instead of SSO. It may not be strong enough, but a user must be authenticated.

Please find below the my analysis on this issue:

1. In web.xml, ProfileFilter is set. This filter does not check SSO flag and call FakeSSOImpl class. In my view filter should do following:
a. If user profile is already set - do nothing
b. If user profile is not set and SSO flag is set - auth ticket should be validated before loading the user profile. (Or if any other filter is already set which is validating ticket first, then it can directly load the user profile. However it would be good if it always validates the ticket same as document execution.)
c. If user profile is not set and SSO flag is not set - login page should be shown for password.

I found workaround for my problem.
1. Comment out this filter in web.xml
2. Now when we directly copy the URL in the browser, Login page is shown.
3. To bypass login page, following url can be used


4. To access a document in iframe window and bypassing login page, following two URLs can be set one after one in the same iframe


To test the same, I used following html


Please review my workaround and if you find any issue or loophole in this approach, could you please send me personal mail.

However if you have some more suggestions, please let everyone know.


Thanks,
Hemant
Hi Antonella,

SSO is disabled in my machine. Then FakeSSO should not be used and user must be redirected to login page.

Thanks,
Hemant
If I provide userId in url itself, SpagoBI is authenticating the user and displaying page based on user roles.
Hi,

I am able to access SpagoBI without using password

http://localhost:8080/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE&user_id=biadmin


It should not happen and login page must come.

How can we prevent this ?

Thanks,
Hemant
Hi Jessica,

Few points which might help you:

1. Parameter is defined in dataset query as well
example: select order from order_product_t where product=$P{ProductNo}

2. When we associate an analytical driver with document, URI name must be same as parameter name in dataset.
URI=ProductNo

Thanks
Hi,

There could be two possible reasons:
1. Some issue in chart template
OR
2. SpagoBI code does not support 2.3.3 version. Some new fields like PANE is not supported

I haven't tried gauge chart, so on the first point, I would not be able to help much.

For second point, lets wait for SpagoBI team confirmation
https://www.spagoworld.org/jforum/posts/list/0/1882.page#6459

Thanks
Hi Antonella,

Would it require any code change OR following steps would suffice:
1. Download latest version of highchart

2. Copy highchart JS files inside SpagoBI/js/lib/highcharts-2.1.6 folder

Thanks
Hemant
Hi Antonella,

What about new chart type like gauge ?
If we put new high chart js files inside highcharts-2.1.6 folder, would it work ?

Thanks,
Hemant
Hi Antonella,

What about new chart type like gauge ?
If we put new high chart js files inside highcharts-2.1.6 folder, would it work ?

Thanks,
Hemant
Hi,

SpagoBI bundles HighChart version 2.1.6.
However gauge is added in HighChart version 2.3.

To make gauge chart, we would have to download latest highchart version and apply it using following steps
http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/highcharts

There may be some hardcoding in SpagoBI code for directory name highcharts-2.1.6. So we can keep the directory name same and update the js files only.

I haven't tried it and would be great if you share findings and result.

Looking forward to see SpagoBI compatibility with latest highchart version.

Thanks
 
Forum Index » Profile for hemgoyal.spw » Messages posted by hemgoyal.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team