phlunk3

Thank you very much for this answer, a quick change to the roles fixed my problem :)

In case it helps, this is the entire error report: Code:org.acegisecurity.AccessDeniedException: Access is deniedorg.acegisecurity.AccessDeniedException: Access is denied at org.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:68) at org.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:275) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:63) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy6.getResource(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.dereference(OlapConnectionServiceImpl.java:498) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.createOlapModel(OlapConnectionServiceImpl.java:106) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeOlapModel(OlapConnectionServiceImpl.java:351) at sun.reflect.GeneratedMethodAccessor413.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy18.initializeOlapModel(Unknown Source) at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:475) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:217) at sun.reflect.GeneratedMethodAccessor262.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:434) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:372) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:141) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

I am creating users along with custom views via a PHP script and am coming up against the following error " Access denied: You do not have permission to take the requested action. " when trying to view the OLAP View with one of my created users. From the folders view I can click on the same item and see my access rights as "Modify, Delete" and all folders which this OLAP View is nested inside give the access level of "Read Only", can anybody suggest where I may be going wrong? When I create a user/OLAP view I am also doing the following with permissions: $sql = 'INSERT INTO JIObjectPermission (uri,recipientobjectclass,recipientobjectid,permissionMask) VALUES ("'.$uri.'","com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser",'.$userid.',1)'; This should give full access to this OLAP View for the user. I am also setting the accesslevel to 0 for a user group which I put every user in, I am expecting this to be overridden if the user has access, is this a correct assumption?

We are using the OLAP view to allow different members of our admin panel to access different parts of the same data set, creating custom slicers on the views to limit their access, however they can ofcourse always edit the MDX query in the OLAP view mode to see things we would rather they couldn't, is it possible to disable use of the MDX query editing panel for some users/a role?

now its suddenly working again, thanks to whomever wrote the blog, I think anandharaj, was a big help!

Okay, I have restarted the jasperServer and logins work properly, however now when I attempt to inspect an OLAP view, I recieve the error that my database connection string is no longer working, how can this be?

I followed these instructios to try set encoding to md5, can anyone tell me why this isnt working and I am still able to login with the old user/pass in the original encoding method? Code:G. How to change password encoding to MD5/SHA?Starting from JasperServer 3.5, the password encryption is enabled by default. Since there are quit number of encoding mechanism available, some of us want to change the default encoding to MD5 or SHA.This might be necessary to follow the organization's standard / policy or to synchronize the user details from other system which store the password in MD5 / SHA. To change the encoding, edit the $JASPER_ROOT/WEB-INF/applicationContext-security.xml, look for "passwordEncoder" bean.Original: <bean id="passwordEncoder" class="com.jaspersoft.jasperserver.api.metadata.common.service.impl.PasswordCipherer" lazy-init="false"> <property name="allowEncoding"><value>true</value></property> <property name="keyInPlainText"><value>false</value></property> <property name="secretKey"><value>0xC8 0x43 0x29 0x49 0xAE 0x25 0x2F 0xA1 0xC1 0xF2 0xC8 0xD9 0x31 0x01 0x2C 0x52 0x54 0x0B 0x5E 0xEA 0x9E 0x37 0xA8 0x61</value></property> <property name="secretKeyAlgorithm"><value>DESede</value></property> <property name="cipherTransformation"><value>DESede/CBC/PKCS5Padding</value></property> </bean>MD5: <bean id="passwordEncoder" class="org.acegisecurity.providers.encoding.Md5PasswordEncoder"> <property name="encodeHashAsBase64"><value>false</value></property> </bean>SHA: <bean id="passwordEncoder" class="org.acegisecurity.providers.encoding.ShaPasswordEncoder"> <property name="encodeHashAsBase64"><value>false</value></property> </bean>

By default what encryption method is jasperServer 3.5 using for user creation? I am attempting to create a script for the user creation after upgrading to 3.5 yesterday and have ran into the problem, any help would be great thank you.

<CalculatedMember datatype="Numeric" name="Profitibility %" formatString="Iif(Value > 0, '|($#,##0.00)|style=green', '|$#,##0.00|style=red')" formula=" IIF( [Measures].[Turnover] > 0, ([Measures].[Profit]/[Measures].[Turnover])*100, 0 )" dimension="Measures" visible="true"> </CalculatedMember> Okay, so I think its obvious what I want my formatString to do, have also tried it with this format: <CalculatedMemberProperty name="FORMAT_STRING" expression="Iif(Value > 0, '|($#,##0.00)|style=green', '|$#,##0.00|style=red')"/> Can anybody provide me with the correct format for a conditional styling parameter?

The community here is small and only a small number of posters contribute unfortunately. I have been using the forums for a week or two now to try and get answers and find that if someone knows the answer, it is usually posted within a couple of days, however often I receive no replies either. Good luck with finding the answer, sorry this is not something I have dealt with thus far in jasper.

I would also like to know if this is a possibility, preferably I wish to be able to fill my username field with the logged in user, however a prompt would be the next best possibility. Someone, please tell us if this is an option :P

In my mdx query I set a default sorting, however it seems that jasper ignores this in the view setting unless the sorting is enabled by clicking the associated buttons in the view, is this the case? or am I doing something wrong? My MDX Query is as follows: select NON EMPTY {[Measures].[Profitibility %], [Measures].[Profit], [Measures].[Percentage Invoiced], [Measures].[Turnover], [Measures].[budgetted], [Measures].[Worked Hours], [Measures].[No Status], [Measures].[Over Budget], [Measures].[internal], [Measures].[Ready to be Invoiced Hours], [Measures].[invoiced Hours], [Measures].[Costs]} ON COLUMNS, NON EMPTY Order({([Date], [Department], [Company Group], [Employee])}, [Measures].[Turnover], DESC) ON ROWS from [realised_hours]

Finally found the solution, was very simple: datatype="Numeric" ; Post Edited by phlunk3 at 05/20/2009 12:04

I have tried this as I thought it may supress the problem: formula="( IIF( ([Measures].[invoiced Hours]/[Measures].[Worked Hours])>0, [Measures].[invoiced Hours]/[Measures].[Worked Hours], 0 ) )" However I guess I need something along the lines of a check as to wether the result is numeric, can this be done in jasperServer? Thank you for any help.

Just incase my question is somewhat confusing I will try and explain my predicament. I have a fact table like this: Hours Job Allowed Hours User 1 1 2 phlunk3 1 1 2 phlunk3 Basically, 2 hours are worked on this job and 2 hours are allowed to be worked, so hours is aggregated with sum and allowed hours is done with max. Now my problem comes, that when I am higher in the view, the max is no longer required, so it must then be aggregated with sum. Can this be done? or do I need to change my fact table to allow sum/create a second measure.