catador

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

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

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

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

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

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

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.

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

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>

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

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!

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

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

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

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!!