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

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>

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!

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!

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

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.

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

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

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.

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

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