[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: sadiqkhoja.spw
Forum Index » Profile for sadiqkhoja.spw » Messages posted by sadiqkhoja.spw
Author Message
how did you resolve that?
Solved the problem.

to achieve mentioned feature I had to modify sbi-all-debug.js file. Here is what I did. Suggestions for improvement are welcomed.

1- changed following code in initDocumentExecutionPage: function() {

if (this.parametersSelectionPage.isParameterPanelReadyForExecution === true) {
documentExecutionPageConfig.hideParametersPanel = true;
}


to

if (this.parametersSelectionPage.isParameterPanelReadyForExecution === true) {
if(this.parametersSelectionPage.parameters == undefined)
documentExecutionPageConfig.hideParametersPanel = true;
else
documentExecutionPageConfig.hideParametersPanel = false;
}


2- modified following code in initializeParametersPanel: function( parameters ) {

if( this.parameterHasOnlyOneValue( parameters[i] ) ) {
if( this.parameterHasDependencies( parameters[i] ) || parameters[i].type === 'DATE') {
this.addField(field, nonTransientField++);
} else {
field.isTransient = true;
field.setValue(parameters[i].value);
}
} else {
if ( this.parameterValueIsInPreferences(parameters[i]) ) {
field.setValue(this.preferenceState[parameters[i].id]);
} else {
if (parameters[i].visible === true && parameters[i].vizible !== false) {
this.addField(field, nonTransientField++);
}
}
}

this.fields[parameters[i].id] = field;
}

if(this.thereAreParametersToBeFilled() !== true) {
if (this.rendered) {
Ext.DomHelper.append(this.body, '<div class="x-grid-empty">' + LN('sbi.execution.parametersselection.noParametersToBeFilled') + '</div>');
}
} else {


to

if( this.parameterHasOnlyOneValue( parameters[i] ) ) {
if( this.parameterHasDependencies( parameters[i] ) || parameters[i].type === 'DATE') {
this.addField(field, nonTransientField++);
} else {
field.isTransient = true;
field.setValue(parameters[i].value);
}
} else {
if ( this.parameterValueIsInPreferences(parameters[i]) ) {
field.setValue(this.preferenceState[parameters[i].id]);
this.addFieldT(field, nonTransientField++);
} else {
if (parameters[i].visible === true && parameters[i].vizible !== false) {
this.addField(field, nonTransientField++);
}
}
}

this.fields[parameters[i].id] = field;
}

if(this.thereAreParametersToBeFilled() !== true) {
if (this.rendered) {
//Ext.DomHelper.append(this.body, '<div class="x-grid-empty">' + LN('sbi.execution.parametersselection.noParametersToBeFilled') + '</div>');
}
} else {


3- added following function after addField: function(field, index) function
, addFieldT: function(field, index) {
field.isTransient = true;
field.columnNo = (index)%this.columns.length;
this.columns[field.columnNo].add( field );
}
ok.
Can you guide me in which source files I have to make changes to enable this feature? Because I want user to be able modify value of parameter when document is executed directly? I have attached a direct link to document in a cockpit.
help please
Hi,

I want to show current logged in user's name in Header instead of toolbar, How to do that?
Hi,

When I am executing document directly using URL, Spago doesn't show me parameter panel (collapsible).

http://localhost:8080/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE&OBJECT_LABEL=HIGHCHART_BAR_CROSED&PARAMETERS=State%3DAL

Is there any argument that can be given to URL to show me collapse parameter panel?
It seems that there is bug in Cross Navigation. If my category contains ampersand (&) then only characters before it are passed to next document. For Example:



when user clicks on first column then



which says Analytical Driver Zone can't assume value 'A' however first chart should be sending 'A & B'

Thanks
Sadiq Khoja
Nisha,

Any update regarding this?
1) No Drilldown on Charts (Cross Navigation is just like drill through)
2) No Graphical Analysis on OLAP Cube (JPivot and JPalo are pivot tables with limited graphical options)
3) Documentation is very limited
4) Key-Value dimension can't be used as category in Charts (for details: http://www.spagoworld.org/jforum/posts/list/2264.page)
5) Prompts are not AJAX-Based, user has to press 'Execute' button after selecting prompt values

For more user experience, play with demo site : http://spagobi.eng.it/SpagoBI


but remember SpagoBI is absolutely FREE


Regards,
Sadiq Khoja
thanks for responding.

Is there any guide for customizing SpagoBI or some architecture overview of it so that I can add this feature in it?
actually 'Zone_Code' is the primary key of 'Zone' and in chart I want to show just 'Zone' (x-axis) but when user click on column then 'Zone_Code' should be passed to next document.

If I select 'CATEGORY' in drill then 'Zone' is passed
If I select 'SERIE' in drill then value of y-axis is passed


Here is the sample data:


I want to pass field value(which is Zone_Code) in Drill Parameter, here is my template:

<HIGHCHART width="100%" height="100%">
<CHART defaultSeriesType="column"/>
<TITLE text="Contribution Details"/>
<LEGEND/>
<SUBTITLE text="Year: $P{Year} Month: $P{Month}"/>
<X_AXIS alias="Zone">
<TITLE/>
</X_AXIS>
<Y_AXIS>
<TITLE/>
</Y_AXIS>
<PLOT_OPTIONS>
<COLUMN>
<DATA_LABELS/>
</COLUMN>
</PLOT_OPTIONS>
<DRILL document="CND_Regionwise">
<PARAM_LIST>
<PARAM name="Zone_Code" type="CATEGORY"/>
</PARAM_LIST>
</DRILL>
<SERIES_LIST>
<SERIES name="Contribution" alias="Zone_Code,Contribution" type="column"/>
</SERIES_LIST>
</HIGHCHART>

How to do that?

Thanks
Hi,

Is there any way to navigate from one cockpit to another cockpit?

Thanks,
Sadiq Khoja
Help Please
Help Please
 
Forum Index » Profile for sadiqkhoja.spw » Messages posted by sadiqkhoja.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team