Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Export cockpit-table dataset with parameters

0 votes
1 view

Hi, I made a cockpit table with a dataset that has 2 parameters, the table show data in cockpit but when I export the cockpit to excel it does not generate data. If the same dataset i will remove the parameters and export the cockpit, it generates data in the excel file. What i doing wrong?

Environment knowage 6.1 - Ubuntu server 16 lts
in Reporting by (320 points)
Do you have any error in your logs?
by (15.2k points)

Yes:

it.eng.spagobi.tools.dataset.exceptions.ParametersNotValorizedException: The following parameters have no value [fecha_desde, fecha_hasta]
        at it.eng.spagobi.tools.dataset.DatasetManagementAPI.setDataSetParameters(DatasetManagementAPI.java:2052)
        at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:365)
        at 

[http-bio-8585-exec-3] 20 Nov 2017 13:33:56,550 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponseFromGenericException:73 - Catched service error:
it.eng.spagobi.utilities.exceptions.SpagoBIRestServiceException: generic.error
        at it.eng.spagobi.api.v2.DataSetResource.getDataStorePost(DataSetResource.java:712)
        at sun.reflect.GeneratedMethodAccessor836.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
        at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

Parameters dataset:

Preview dataset with parameters:

Cockpit data configuration:

Cockpit edition mode:

Cockpit show data:

I hope yours can help me.

Thanks.

by (320 points)
Sure it helps! For the future, please provide all these info in the original question, so that we can help you quickly!
by (15.2k points)

1 Answer

0 votes

At the time being, the cockpit export re-execute the document as it was statically defined. 

Thus, it is not able to export the cockpit with the parameters and selections taken at execution time. That's why you will see the error

it.eng.spagobi.tools.dataset.exceptions.ParametersNotValorizedException: The following parameters have no value [fecha_desde, fecha_hasta]

What you can do is to provide default to the parameter's value. I guess it is not the same, but this is a export limit that cannot be overcome. I will file a JIRA issue for you about this, hopefully to have it solved in one of the next releases: https://www.knowage-suite.com/jira/browse/KNOW-51

by (15.2k points)
edited by
Ok thank you
by (320 points)
Powered by Question2Answer
...