tellranga

I see, can you point out which roles & permission you added explicitly.

Thanks Sherman, I need one more clarification, Since all my Analysis Report is built on complicated query refering multiple tables, I had a tough time building the mondrian xml ( despite using the workbench tool to generate such xml). So, I decided to create a seperate view for each analysis report based on the corresponding query which the report is dependent on. To eloborate further I will take your above table defenition as an example, If the base sql Query for the above report is select year, product name,sales, some expression 'sales growth' from product,time,fact where product.product_id=fact.product_id and time.time_id=fact.time_id order by year,product_name I will create a view caled SalesByYear_View with the same query defenition, create view sales_by_year_view as select year, product name,sales, expression 'sales growth' from product,time,fact where product.product_id=fact.product_id and time.time_id=fact.time_id order by year,product_name Next I will generate my mondrian xml focussing only on a single object SalesByYear_View .It helped me to resolve two major issues, generating mondrian xml became simple keeping only one object / view in front of me calculating expressions for fields like sales growth % also became simple (since the expression is already defined in view)So my question is in terms of best practice for Analysis Report, my decision to create a seperate view for each analysis report based on the corresponding query which the report is dependent on is right or wrong ?Note - This means if I have to generate 10 differnet Analys report, I will end up creating 10 different views.

I was given the output of a sample report as below to generate one as a POC, Year 2000 2001 Growth Product sales sales sales Total 1600 1800 12.5% ---Audio CD 600 900 50.0% ---Video CD 500 250 -50.0% ---Books 500 650 30.0% ------Fiction 300 300 00.0% ------Non-fiction 200 350 75.0% For the above BI Report, I can plan my mondrian xml to have Dimension as Year, Product Measures as Yearly sales (2000, 2001) and finally Growth sales as a calculated member in mdx query.Assuming my above conventions are correct, how many tables should I create, and on which key field, should I have to set the parent child relationship across tablesI am confused in desighning the tables, so can you please pass the sql scripts required to creat the table ?

Please find my reply, Thats true, no environmental changes was done ( like browser upgrade / system configuration etc). It is JasperServer V2.1 Community Edition for Windows OS. Yes, this is the only action I get error (infact the last step, clicking save button in the validation Screen). Existing analysis view which comes as samples are working fine (like foodmart) .Also, I uninstalled Jasper Server V2.1 and installed V3.1, but still same error. So I reverted back to V2.1 itself where I atleast saw a working version of analysis view for some time . But offcource, now I am unable to come out of this exception ... looks like a dead end... Post Edited by tellranga at 07/13/2009 08:31

Tried to save the file by doing the following. But none of them worked, first, I created a new folder, next, I created a new user in jasper console with admin access finally, I tried the new user with different rolesDuring these experimentation, I also ensured my windows network user is having admin access. But all my above effort ended up in the same exception, "Access denied: You do not have permission to take the requested action"very strange ?

Thanks, But I am using Jasper Server V2.1. in Windows OS as a jasperadmin user with default role settings, I logged into jasper admin console and uploaded a Modrian XML file which has cube definitions. After giving a query in MDX Query Screen, I can see a success message, "The OLAP connection was successfully validated.". But finally when I click save button in the validation Screen, I am getting an exception, "Access denied: You do not have permission to take the requested action" com.jaspersoft.jasperserver.api.JSException: org.acegisecurity.AccessDeniedException: Access is denied. But surprisingly, this unaltered xml file without any environmental change did worked on previous occations. The working version all of a sudden is not working which puzzles me. Any help, would be highly appreciated ?

Hi, As a jasperadmin user with default role settings, after clicking the save button in the jasper admin console, I am getting an exception as "Access denied: You do not have permission to take the requested action" Previous screen to this error page in the server console says, the file is succesfully validated. Code:Access denied: You do not have permission to take the requested action. com.jaspersoft.jasperserver.api.JSException: org.acegisecurity.AccessDeniedException: Access is deniedcom.jaspersoft.jasperserver.api.JSException: org.acegisecurity.AccessDeniedException: Access is deniedat com.jaspersoft.jasperserver.war.action.OlapUnitAction.saveOlapUnit(OlapUnitAction.java:441)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.java:103)at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)at org.springframework.webflow.engine.State.enter(State.java:200)at org.springframework.webflow.engine.Transition.execute(Transition.java:229)at org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112)at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572)at org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207)at org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:214)at org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238)at sun.reflect.GeneratedMethodAccessor171.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.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)at $Proxy13.resume(Unknown Source)at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115)at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)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.doPost(FrameworkServlet.java:360)at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)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.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:136)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:131)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:131)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)Caused by: org.acegisecurity.AccessDeniedException: Access is deniedat 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.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 $Proxy1.saveResource(Unknown Source)at com.jaspersoft.jasperserver.war.action.OlapUnitAction.saveOlapUnit(OlapUnitAction.java:439)... 84 moreorg.acegisecurity.AccessDeniedException: Access is deniedorg.acegisecurity.AccessDeniedException: Access is deniedat 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.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 $Proxy1.saveResource(Unknown Source)at com.jaspersoft.jasperserver.war.action.OlapUnitAction.saveOlapUnit(OlapUnitAction.java:439)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.java:103)at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)at org.springframework.webflow.engine.State.enter(State.java:200)at org.springframework.webflow.engine.Transition.execute(Transition.java:229)at org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112)at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572)at org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207)at org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:214)at org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238)at sun.reflect.GeneratedMethodAccessor171.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.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)at $Proxy13.resume(Unknown Source)at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115)at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)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.doPost(FrameworkServlet.java:360)at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)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.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:136)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:131)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:131)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)