[drillthrough customization]

Hi to all,

 

In 2006 i ask for drillthrough customization, beacause if i remember well, jpivot allow choose fact table fields on drillthrough.  In jasperServer 3.7.1 looks like the drillthrough customizations it's not enabled... on Profesional or enterprise it's??

Best Regards,

 

Arturo

[Where is JasperAnalysis Workbench?]

You right! i don't see that files... the insistence makes me blind... :S

 

thanks!

[Where is JasperAnalysis Workbench?]

Uhm... must review 3.5.4 release... there is the file http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%203.5.0/JasperAnalysis-Workbench-3.5.4.zip/download

 

 

[Where is JasperAnalysis Workbench?]

Hello,

 

I'm too looking for workbench and can't find... the url it's broken, where is??

 

Thanks!

 

Arturo

[really really really stuck with formula]

Hi to all,

 

After compiling very many patience and reviewing character to character the scheme I found east detail

 

Code:

  formatString="Currency"

      ifformula="Iif([Measures].[ValorTrx] = 0,0,[Measures].[ValorTrx])/[Measures].[Qty])"/>

that I do not know in which moment I wrote it, but when i replace with formula, throw me error over ) that it's wrong.

 

ifformula it's any property of calculated member? i search on mondrian documentation but not find anything.

 

Best Regards!!

 

Catador

[really really really stuck with formula]

Hi...

 

Sorry by make other thread by this problems it's make me spent so much time. I have a mdx query like this:

 

Code:

with member [Measures].[VarCuLPer] as ' ([Producto].CurrentMember,[Measures].[VarCuLP])', FORMAT_STRING = IIf(([Measures].[VarCuLP] <= 100), IIf(([Measures].[VarCuLP] <= 0.0), "|#|style=green", "|#|style=yellow"«»), "|#|style=red"«»)
select  {[Measures].[Qty], [Measures].[CuActual], [Measures].[CuLP],  [Measures].[VarCuLPer], [Measures].[VarCierreLY] } ON COLUMNS,
 {[Producto].[All Productos], [Producto].[All Productos].[FPC       ], [Producto].[All Productos].[PBB       ], [Producto].[All Productos].[Producto T], [Producto].[All Productos].[servicio  ]} ON ROWS
from [Existencias]
where [FechaDocumento].[All FechaDocumentos].[2006].[10]

 

with this cube declaration

Code:

[code] <Cube name="Existencias"> <Table name="Tabla_Fact_DM_EXISTENCIAS"/> <DimensionUsage foreignKey="TIPO_MOVIMIENTO_KEY" name="TipoMovimiento" source="TipoMovimiento"/> <DimensionUsage foreignKey="PRODUCTO_KEY" name="Producto" source="Producto"/> <DimensionUsage foreignKey="CIERRE_KEY" name="FechaDocumento" source="FechaDocumento" /> <Measure aggregator="sum" column="cantidad" formatString="Standard" name="Qty"/> <Measure aggregator="sum" column="valor" formatString="#,###.00" name="ValorTrx"/> <Measure aggregator="count" column="cantidad" name="QMovs"/> <Measure aggregator="sum" column="costopromedio" formatString="#,###.00" name="CuTrx"/> <CalculatedMember name="CuActual" dimension="Measures" formatString="Currency" ifformula="Iif([Measures].[ValorTrx] = 0,0,[Measures].[ValorTrx])/[Measures].[Qty])"/> <CalculatedMember name="CuLP" dimension="Measures" formatString="Currency" formula="Iif([Measures].[CuActual] = 0,0,([Measures].[CuActual],[FechaDocumento].CurrentMember.PrevMember))" > <CalculatedMemberProperty name="SOLVE_ORDER" value="1"/> </CalculatedMember> <CalculatedMember name="VarCuLP" dimension="Measures" formatString="#,###.00" formula="Iif([Measures].[CuActual] = 0, 0, ([FechaDocumento].CurrentMember,[Measures].[CuActual])-([FechaDocumento].CurrentMember.PrevMember,[Measures].[CuActual]))"> <CalculatedMemberProperty name="SOLVE_ORDER" value="1"/> </CalculatedMember> <CalculatedMember name="Var%CuLP" dimension="Measures" formatString="#,###.00" formula="Iif([Measures].[CuLP] = 0, 0, (([Measures].[VarCuLP]/[Measures].[CuLP]) - 1))"> <CalculatedMemberProperty name="SOLVE_ORDER" value="2"/> </CalculatedMember> <CalculatedMember name="VarCierreLY" dimension="Measures" formula="Iif([Measures].[CuActual] = 0, 0, ([FechaDocumento].CurrentMember,[Measures].[CuActual]) - (ClosingPeriod(Mes,[FechaDocumento].CurrentMember.Parent.PrevMember), [Measures].[CuActual]))"> <CalculatedMemberProperty name="SOLVE_ORDER" value="3"/> </CalculatedMember>

 

and when i make the olap view when validate the query throw this error:

Code:

[code] 16:04:49,564 WARN OlapConnectionServiceImpl,http-8080-1:188 - Validation Failed for Olap Unit: Vi staCostos [Ljava.lang.StackTraceElement;@a2bb54 16:04:49,566 ERROR OlapConnectionServiceImpl,http-8080-1:190 - java.lang.NullPointerException java.lang.NullPointerException at mondrian.olap.Util.replace(Util.java:195) at mondrian.olap.Util.singleQuoteString(Util.java:751) at mondrian.rolap.RolapCube.preCalcMember(RolapCube.java:643) at mondrian.rolap.RolapCube.createCalcMembersAndNamedSets(RolapCube.java:488) at mondrian.rolap.RolapCube.init(RolapCube.java:398) at mondrian.rolap.RolapCube.<init>(RolapCube.java:236) at mondrian.rolap.RolapSchema.load(RolapSchema.java:309) at mondrian.rolap.RolapSchema.load(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:159) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:49) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:802) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:636) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:138) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:73) at mondrian.olap.DriverManager.getConnection(DriverManager.java:120) at mondrian.olap.DriverManager.getConnection(DriverManager.java:87) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.ge tMondrianConnection(OlapConnectionServiceImpl.java:230) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.va lidateMDX(OlapConnectionServiceImpl.java:176) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.va lidate(OlapConnectionServiceImpl.java:165) at com.jaspersoft.jasperserver.war.validation.OlapUnitValidator.validateMdxQuery(OlapUnitV alidator.java:129) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.jav a:231) at org.springframework.webflow.action.FormAction.invokeValidatorMethod(FormAction.java:682 ) at org.springframework.webflow.action.FormAction.doValidate(FormAction.java:656) at org.springframework.webflow.action.FormAction.bindAndValidate(FormAction.java:530) at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.jav a:231)

 

Please this have me stuck for much time, i'm really gratefull if anyone can help me please...

 

thanks

[Jasperserver with Active Directory]

Hi,

 

i'm try the authentication through Active Directory with OpenI, and have a lot of problems, beacuse active directory in win2k3 doesn't allow the anonymous find, then when you made the conection with AD you must provide a user with domain adminitrator. After this, the only one user what can access was this domain administrator. My question it's you have been trying with AD from w2k3? with a connection like this?

 

Best Regards,

 

Catador.

[formula error with <> symbols]

Hi,

 

This begins to be very hard. if i have a formula like this...

Code:

  <CalculatedMember name="CuActual" dimension="Measures"
      formatString="Currency"
      ifformula="Iif(([Producto].CurrentMember,[Measures].[ValorTrx],[FechaDocumento].CurrentMember.PrevMember) = 0,null,([Producto].CurrentMember,[Measures].[ValorTrx])/([Producto].CurrentMember,[Measures].[Qty]))"/>

 

with a mdx like this:

Code:

[code]with member [Measures].[VarCuLPer] as ' ([Producto].CurrentMember,[Measures].[VarCuLP])', FORMAT_STRING = IIf(([Measures].[VarCuLP] <= 100), IIf(([Measures].[VarCuLP] <= 0.0), "|#|style=green", "|#|style=yellow"«»), "|#|style=red"«») select {[Measures].[Qty], [Measures].[CuActual], [Measures].[CuLP], [Measures].[VarCuLPer], [Measures].[VarCierreLY] } ON COLUMNS, {[Producto].[All Productos], [Producto].[All Productos].[FPC ], [Producto].[All Productos].[PBB ], [Producto].[All Productos].[Producto T], [Producto].[All Productos].[servicio ]} ON ROWS from [Existencias] where [FechaDocumento].[All FechaDocumentos].[2006].[10]

i'm getting this error:

Code:

[code] 17:52:09,629 WARN OlapConnectionServiceImpl,http-8080-2:188 - Validation Failed for Olap Unit: nu ll [Ljava.lang.StackTraceElement;@1e926fd 17:52:09,631 ERROR OlapConnectionServiceImpl,http-8080-2:190 - java.lang.NullPointerException java.lang.NullPointerException at mondrian.olap.Util.replace(Util.java:195) at mondrian.olap.Util.singleQuoteString(Util.java:751) at mondrian.rolap.RolapCube.preCalcMember(RolapCube.java:643) at mondrian.rolap.RolapCube.createCalcMembersAndNamedSets(RolapCube.java:488) at mondrian.rolap.RolapCube.init(RolapCube.java:398) at mondrian.rolap.RolapCube.<init>(RolapCube.java:236) at mondrian.rolap.RolapSchema.load(RolapSchema.java:309) at mondrian.rolap.RolapSchema.load(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:159) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:49) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:802) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:636) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:138) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:73) at mondrian.olap.DriverManager.getConnection(DriverManager.java:120) at mondrian.olap.DriverManager.getConnection(DriverManager.java:87) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.ge tMondrianConnection(OlapConnectionServiceImpl.java:230) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.va lidateMDX(OlapConnectionServiceImpl.java:176) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.va lidate(OlapConnectionServiceImpl.java:165) at com.jaspersoft.jasperserver.war.validation.OlapUnitValidator.validateMdxQuery(OlapUnitV alidator.java:129) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.jav a:231)

 

thanks for your help because i'm stuck...

 

bye

[formula error with <> symbols]

this it's the formula:

 

Code:

 <CalculatedMember name="VarCuLP" dimension="Measures"
      formatString="#,###.00"
      formula="Iif([Measures].[CuActual] <> 0, ([FechaDocumento].CurrentMember,[Measures].[CuActual])-
([FechaDocumento].CurrentMember.PrevMember,[Measures].[CuActual]),null)">
      <CalculatedMemberProperty name="SOLVE_ORDER" value="1"/>
      </CalculatedMember>

[formula error with <> symbols]

Hello,

 

when i write a formula like this:

 

appear this error on logs..

 

10:18:02,151 ERROR JSErrorPage_jsp,http-8080-1:128 -

org.eigenbase.xom.XOMException: Document parse failed: [Fatal Error] :1:2029: The value of attribut

e "ifformula" associated with an element type "CalculatedMember" must not contain the '<' character

.

 

i can't do it a formula with "<" symbol? how can i do a formula with if it's distinct to zero??

 

Thanks for your help!!

 

Catador

[color for style on mdx query]

Hi,

 

When i use orange color, cell value appear left ident and white background, but i can work, no exists any signal of error, a bug?

 

best regards,

 

catador!

[it's possible add measures to drilltrough fields?]

Hi Sherman,

 

one week ago, i contact a sales representant of jasperintelligence, and tell me what the only difference between Pro and OSS it's support...

 

do you have a detail of additionals functionalities of Pro and OSS?

 

thanks

[color for style on mdx query]

Hi Sherman,

 

If i search css files in jasperserver webapp exist those:

./cal/calendar-win2k-1.css

./wcf/form/xform.css

./wcf/tree/xtree.css

./wcf/table/xtable.css

./wcf/pagestack/pagestack.css

./wcf/tabbed/xtabbed.css

./wcf/status/status.css

./wcf/wcf.css

./wcf/catedit/xcatedit.css

./stylesheets/stylesheet.css

./stylesheets/base.css

./stylesheets/styles.css

./jpivot/navi/mdxnavi.css

./jpivot/table/mdxtable.css

 

just in mdxtable i found the definition of sytles... and i add orange definition...

 

/* data cells */

td.cell-even,

td.cell-odd,

td.cell-red,

td.cell-yellow,

td.cell-green,

td.cell-rot,

td.cell-gelb,

td.cell-gruen,

td.cell-orange, -> i add this

td.cell-naranjo, -> i add this

td.property-value,

td.property-span {

font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size: 0.8em;;

color : Black;

text-align: right;

}

 

and this..

td.cell-orange,

td.cell-naranjo,

span.cell-orange,

span.cell-naranjo

{

background-color: #FD9C03;

}

 

it's ok this? because just mdxtable file have this definitions.

 

Thanks for your help.

 

:D

[help with variable please!!]

this is:

 

with member [Measures].[Var%CuLP] as 'Iif([Producto].CurrentMember.Level.Name = "Codigo Referencia ",(([Measures].[VarCuLP] * 100.0) / ([Producto].CurrentMember, [Measures].[CuLP])),(([Measures].[VarCuLP] * 100.0) / ([Producto].CurrentMember, [Measures].[CuLP])))',

FORMAT_STRING = IIf(([Measures].[Var%CuLP] < 15.0), IIf(([Measures].[Var%CuLP] < 10.0), IIf(([Measures].[Var%CuLP] < 0.0), "|#|style=green","|#|style=yellow"),"|#|style=yellow"), "|#|style=red")

select {[Measures].[Qty], [Measures].[CuActual], [Measures].[CuLP], [Measures].[VarCuLP], [Measures].[Var%CuLP], [Measures].[VarCierreLY] } ON COLUMNS,

{[Producto].[All Productos], [Producto].[All Productos].[FPC ], [Producto].[All Productos].[PBB ], [Producto].[All Productos].[Producto T], [Producto].[All Productos].[servicio ]} ON ROWS

from [Existencias]

where [FechaDocumento].[All FechaDocumentos].[2006].[2]

 

Thanks for any help, i'm really confused

[starting jasperserver on tomcat 5.5.16]

Do yo schedule anything?? beacuse looks like you 've a missconfigured schedule... this part of trace say it

 

16:06:10,515 ERROR [/jasperserver],Thread-1:3733 - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'maintenanceScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-logging.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerException: Based on configured schedule, the given trigger will never fire.

org.quartz.SchedulerException: Based on configured schedule, the given trigger will never fire.

 

maybe you must check your scheduling configuration.

 

Good Luck!!

[help with variable please!!]

Ok... this is

 

<?xml version="1.0"?>

<Schema name="Puig">

<Dimension name="Producto">

<Hierarchy hasAll="true" primaryKey="PRODUCTO_KEY">

<Table name="Dim_Producto_Existencias"/>

<Level column="NombreDivision" name="Nombre Division"/>

<Level column="NombreCasa" name="Nombre Casa"/>

<Level column="NombreMarca" name="Nombre Marca"/>

<Level column="CodigoReferencia" name="Codigo Referencia">

<Property name="NombreReferencia" column="NombreReferencia"/>

</Level>

</Hierarchy>

</Dimension>

<Dimension name="TipoMovimiento">

<Hierarchy hasAll="true" primaryKey="TIPO_MOVIMIENTO_KEY">

<Table name="Dim_Tipo_Movimiento"/>

<Level column="TipoMovimiento" name="TipoMovimiento"/>

<Level column="SubTipoMovimiento" name="SubTipoMovimiento"/>

</Hierarchy>

</Dimension>

<Dimension name="FechaDocumento" type="TimeDimension">

<Hierarchy hasAll="true" primaryKey="CIERRE_KEY">

<Table name="dim_cierre_ex"/>

<Level name="Ano" column="Ano" type="Numeric" uniqueMembers="true" levelType="TimeYears"/>

<Level name="Mes" column="CodigoMes" uniqueMembers="false" type="Numeric" levelType="TimeMonths"/>

</Hierarchy>

</Dimension>

<Cube name="Existencias">

<Table name="Tabla_Fact_DM_EXISTENCIAS"/>

<DimensionUsage foreignKey="TIPO_MOVIMIENTO_KEY" name="TipoMovimiento" source="TipoMovimiento"/>

<DimensionUsage foreignKey="PRODUCTO_KEY" name="Producto" source="Producto"/>

<DimensionUsage foreignKey="CIERRE_KEY" name="FechaDocumento" source="FechaDocumento" />

<Measure aggregator="sum" column="cantidad" formatString="Standard" name="Qty"/>

<Measure aggregator="sum" column="valor" formatString="#,###.00" name="ValorTrx"/>

<Measure aggregator="count" column="cantidad" name="QMovs"/>

<Measure aggregator="sum" column="costopromedio" formatString="#,###.00" name="CuTrx"/>

<CalculatedMember name="CuActual" dimension="Measures"

formatString="Currency"

formula="([Producto].CurrentMember,[Measures].[ValorTrx])/([Producto].CurrentMember,[Measures].[Qty])"/>

 

<CalculatedMember name="CuLP" dimension="Measures" formatString="Currency"

formula="([Measures].[CuActual],[FechaDocumento].PrevMember)" >

<CalculatedMemberProperty name="SOLVE_ORDER" value="1"/>

</CalculatedMember>

 

<CalculatedMember name="VarCuLP" dimension="Measures"

formatString="#,###.00"

formula="([FechaDocumento].CurrentMember,[Measures].[CuActual])-([FechaDocumento].CurrentMember.PrevMember,[Measures].[CuActual])">

<CalculatedMemberProperty name="SOLVE_ORDER" value="1"/>

</CalculatedMember>

 

<CalculatedMember name="VarCierreLY" dimension="Measures"

formula="([FechaDocumento].CurrentMember,[Measures].[CuActual]) - (ClosingPeriod(Mes,[FechaDocumento].CurrentMember.Parent.PrevMember), [Measures].[CuActual])">

<CalculatedMemberProperty name="SOLVE_ORDER" value="3"/>

</CalculatedMember>

 

</Cube>

</Schema>

[color for style on mdx query]

Hi!!

 

Thanks for answer!! i add this to file

td.cell-orange,

td.cell-naranjo,

span.cell-orange,

span.cell-naranjo

{

background-color: #FD9C03;

}

 

but when i put orange on style in mdx query doesn't works fine and no have any error message.

 

thanks for your help!

[color for style on mdx query]

Hi!!

 

Thanks for answer!! i add this to file

td.cell-orange,

td.cell-naranjo,

span.cell-orange,

span.cell-naranjo

{

background-color: #FD9C03;

}

 

but when i put orange on style in mdx query doesn't works fine and no have any error message.

 

thanks for your help!

[help with variable please!!]

Hi to all!!

 

I'm very confused with this!!! look... i've this data:

 

qty unitcost costlast difunitcost %varUC

period coslastperiod lastper

Line1 7678 527.4 2273.3 -1745.9 -331

Prod1 7561 506.11 0 506.11 100

Prod2 0 0 0 0 0

Prod3 0 0 0 0 0

Prod4 3 523.33 0 523.33 100

Prod5 63 2273.3 2273.3 0 0

Prod6 51 1527.76 0 1527.76 100

 

dif unit cost last period it's unitcost - costlastcost

 

and %varUClasper it's a formula as (difunitcost * 100)/unitcost

 

if you see in Line1 the value of %varUClastper its -331 what if whe think its ok. But this % isn't representative of %varUC Products under Line1... i need a variable what help in navigation and search where %var... it's more big and detect cost variations...

 

i really anyone understand my problem and can help me to create a real usefull variable.

 

Thanks!!

[Working with Drill through option in OLAP]

Hello,

 

You are using a Mondrian Connection?? for your olap view? because if u are using a xml/a connection, probably you can't sucessfully drillthrough. With Analisys Services doesn't work drillthrough.

 

If u are using mondrian, by default you obtain descriptions of your dimensiones and the measure where you click the drillthrough arrow.

 

i hope this helps you.

[color for style on mdx query]

Hi!!

 

i have this query

 

with member [Measures].[Var%Rango] as '(([Measures].[VarCuLP] * 100.0) / ([Producto].CurrentMember, [Measures].[CuActual]))', FORMAT_STRING = IIf(([Measures].[Var%Rango] < 15.0), IIf(([Measures].[Var%Rango] < 10.0), IIf(([Measures].[Var%Rango] < 0.0), "|#|style=green", "|#|style=yellow"), "|#|style=HOWPUTORANGE"), "|#|style=red")

select {[Measures].[Qty], [Measures].[CuActual], [Measures].[CuLP], [Measures].[VarCuLP], [Measures].[Var%CuLP], [Measures].[MaxHjs], [Measures].[Var%Rango]} ON COLUMNS,

{[Producto].[All Productos], [Producto].[All Productos].[FPC ], [Producto].[All Productos].[PBB ], [Producto].[All Productos].[Producto T], [Producto].[All Productos].[servicio ]} ON ROWS

 

and i wan't put a orange back color when the values it's between 10 and 15.

 

if i put orange... the number looks left ident, i can put the number in hex? how? :D

 

Thanks for this help... this colors be a great help for directors!!

 

Best Regards!!!

[error at save a new olap client connection]

This error its throw me now the tomcat...

 

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@1232679 targetAction = com.jaspersoft.jasperserver.war.action.OlapClientConnectionAction@b303c1, attributes = map[[empty]]] in state 'saveMondrianConnection' of flow 'olapClientConnectionFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Failed to save connection changes.

 

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@1232679 targetAction = com.jaspersoft.jasperserver.war.action.OlapClientConnectionAction@b303c1, attributes = map[[empty]]] in state 'saveMondrianConnection' of flow 'olapClientConnectionFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Failed to save connection changes.

com.jaspersoft.jasperserver.api.JSException: Failed to save connection changes.

at com.jaspersoft.jasperserver.war.action.OlapClientConnectionAction.saveMondrianConnection(OlapClientConnectionAction.java:596)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 

but not always appear when save a new olap connection. but yes appear when i try modified the xml schema of a connection.

 

Any idea??

[it's possible add measures to drilltrough fields?]

Hi,

 

when i do a drillthrough over a measure the detail showed it's dimension information and the measure what i click.

 

dim1level1 dim1level2 dim2level1 dim2level2 ... mesureselected

 

 

but i want see in detail the others measures, no just the selected, its posible?

 

 

Best Regards,

 

Arturo.

[prompt for parameters]

Hi!

 

using JI it's possible use a prompt for a parameter? i bought documentation, but this doesn't clear.

 

Thanks!

 

Catador

[improving drilltrough]

Hi!

 

I'm wanna deliver a better information with drilltrough, because giving a little bit more information through this way i can improve very strongly reports.

 

i have a fact table like this:

product_key

date_key

movement_key

qty

amount

trxcost

refdoc

 

and any calculated members.

 

my question is, i can add fields to drillthrough report like refdoc (document number) if the answer it's no. I can use a memberproperty like a http url where i call a report where take like parameters productid and datekey and show a report with columns like refdoc, date, amount, qty, etc...

 

Thanks for your help or ideas!!!

 

Bye!!