shivareddyk

hi At the time of creating a cube, possible to give dimension table as a primary table? or we need to give fact table as a primary table? can u reffer attached ppt. could u tell me any one.... Regards

hi, i install mysql db in my pc, at the time of login i enterd Serverhost:"localhost" is aloving to view database schemas from mysql i tried to to enter Sererhost:10.10.0.180(my pc ip config),it is not aloved to view schemas. what it the difference? regards

hi, i install mysql db in my pc, at the time of login i enterd Serverhost:"localhost" is aloving to view database schemas from mysql i tried to to enter Sererhost:10.10.0.180(my pc ip config),it is not aloved to view schemas. what it the difference? regards

hi..... could u tell me any one, how we can identify mysql config file exp:- "my.cnf" our community version supports only mysql or support any other database(oracle) Regards

hi can u explain abt this error... Code:com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Currency.Currency].[All Currency]} ON COLUMNS, NON EMPTY {[Measures].[Total Income]} ON ROWS from [kpi-financial] ]com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Currency.Currency].[All Currency]} ON COLUMNS, NON EMPTY {[Measures].[Total Income]} ON ROWSfrom [kpi-financial]] at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:295) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at sun.reflect.GeneratedMethodAccessor298.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at javax.el.BeanELResolver.getValue(BeanELResolver.java:62) at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53) at org.apache.el.parser.AstValue.getValue(AstValue.java:97) at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186) at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:923) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f2(viewOlap_jsp.java:1639) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:236) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) 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:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:140) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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 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:165) 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:165) 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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Unknown Source)Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Currency.Currency].[All Currency]} ON COLUMNS, NON EMPTY {[Measures].[Total Income]} ON ROWSfrom [kpi-financial]] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1083) at mondrian.olap.Util.newError(Util.java:1099) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:438) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:269) ... 96 moreCaused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum((case when c.glcat='TCI' then locbal else 0 end)) as `m0`, sum((case when c.glcat='IE' then locbal else 0 end)) as `m1` from `fact_gl` as `fact_gl`] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1083) at mondrian.olap.Util.newError(Util.java:1099) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:204) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:246) at mondrian.rolap.agg.Segment.load(Segment.java:354) at mondrian.rolap.agg.Aggregation.load(Aggregation.java:164) at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:81) at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:352) at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:178) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:772) at mondrian.rolap.RolapResult.<init>(RolapResult.java:390) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:410) ... 97 moreCaused by: java.sql.SQLException: Unknown column 'c.glcat' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) at com.mysql.jdbc.Statement.executeQuery(Statement.java:824) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:188) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124) ... 107 more

hi, I taken backup from mysql administrator gui tool(5.0v) from windows PC(JASPERSERVER BACKUP), Q:- Now i need to load this(same database) into Linux server? can u provide detail explanation, how can i upload database into linux server? what steps need to load BI-Setup in Linux server? can u expalin more......i need this typr of setup,we are having different branches with different servers. Regards

hi what is the difference between Topics and Domains at the time of creating Ad Hoc Reports in Jasperseverserver professional 3.5v? if we buy professional version what are the products are included in same package? Regards

hi i am having windows jasperserver backup in my office, Q:-now i need to execute same back up on Linux (another office), how can i do ? Regards

hi I installed jasperserver v3.5 (demo version:30days), Q:-i did't get you any ETL products Along with this version,from where can possible to view ETL icons from jasperserver? Regards

hi ..... I am writing query like this for calculating monthly wise data values. select x.*,y.Impairment from (SELECT a.finyr, a.finpr,b.grptyp,sum(case when b.grptyp = 'PL1' then locbal else 0 end) TotalIncome, sum(case when b.grptyp='PL2' or b.grptyp='PL3' then locbal else 0 end) TotalExpenses, sum(case when b.grptyp = 'PL4' then locbal else 0 end) Taxation, sum(case when b.grptyp = 'BSS' then locbal else 0 end) Equity FROM D_S_GL06MAST a, D_S_GL04SGSTR b WHERE a.compcd = b.compcd AND a.glkey = b.glkey and a.finpr=$P{reportdate} group by finyr,finpr) x,(SELECT a.finyr, a.finpr, sum(locbal) Impairment FROM D_S_GL06MAST a, D_S_GL04SGSTR b, S_CF92PRGL c WHERE a.compcd = b.compcd AND a.glkey = b.glkey AND b.accd = c.glcd AND b.fccd = c.fccd AND c.crline = 'LN' AND c.glfld IN ('GL11', 'GL37', 'GL38', 'GL50', 'GL51')and a.finpr=$P{reportdate} group by finyr,finpr) y where x.finyr=y.finyr and x.finpr=y.finpr that works fine,give result as our input as 1 it gives January data 2 it gives February data, BUT........I need cummulative data...... i put in i-reports settings "sum" in calculation type.but i did not get u cummulative data,any one can help for me...... Thanks in advance.... shiv a

Code:Error Trace: com.jaspersoft.jasperserver.api.JSExceptionWrapper: object references an unsaved transient instance - save the transient instance before flushing: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl; nested exception is org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessApiUsageException: object references an unsaved transient instance - save the transient instance before flushing: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl; nested exception is org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl Caused by: org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl at org.hibernate.engine.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:219) at org.hibernate.type.EntityType.getIdentifier(EntityType.java:397) at org.hibernate.type.ManyToOneType.nullSafeSet(ManyToOneType.java:78) at org.hibernate.persister.collection.AbstractCollectionPersister.writeElement(AbstractCollectionPersister.java:755) at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1143) at org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:26) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)

hi ...... how to compare current month data with last month data from I-Reports designer?(i need to calculate both in same report) how to cummulative data from I-report designer? pls,let me know.......... BestRegards shi va

Hi Srikanth, Could u explain a little bit......how to change colors? i saw in chart properties one option as Customizerclass. but i dont know how to write syntax/how to change properties for that one....can u exp with example ....... Bestregards shiva

hi Could you tell me,how to change defult chart colors?defalut it showing(every chart) RED AND BLUE. if possible can u see attached doc......this chart showing year(2007)as blue color,i need to change blue to another color....how can possible to change? i checked all chart options but i didn't findout . Thanks in Advance.. Bestregards shiva

hi, how can i identify which is main(welcome) jsp page(i have many login pages in my path directory :C:\Program Files\jboss-4.2.2.GA\server\default\deploy\jasperserver.war\WEB-INF\jsp" can u give any idea.....!

hi... i all ready posted .jsp page in my WEB-INF/JSP folder ,but i din't get any changes in Jasperserver? i think......i need to link some where that jsp page(i dont know where i link), jest pass a .jsp page in WEB-INF/JSP folder cannot possible to view. kindly help abt this issue.... Regards shiva

hi lucianc, Could u tell me how to add .jsp file to our jasperserver?

hi swood Could u tell me ,how can possible to add .jsp file in jsaperserver? regards

i think, you can add .jrxml file from add resource option and add ur jrxml file(i report file ) to that jrxml file.

hi ..., I am trying to add (.jsp)to jasperserver process:- 1.select filder from left pannel 2.select add resource icon from top 3.from Addresouce two optios is there(a.jasperserverreport and b. from others-> jrxml file) here(i think) option b is not having Customization. i chose Jasperserver report from Addresource icon 4. a.Naming: login_cssi b.JRXML*(here two options one is file system and another one is from repository) i try use file system it (i add jsp file) error is: parsing error i try use seconde option (from repository)but i dont have any Jrxml file(i had onely jsp file) how can move from this step? I think last option is Customization. could u please inform to me the process,how add jsp file to jasperserver? BestRegards shiva

Dear member, How do u add .html/.jsp page to Jasperserver? I am having .jsp(like ur .html)file but i dont know how to add (jsp page or html page) jasperserver,can u give information regarding to this.. i also suffer like u,how to solve this problem....i dont have much knowledge on java,i am working with BI team. Bestregards shiva

hi Hasham, I am trying to add (.jsp)to jasperserver process:- 1.select filder from left pannel 2.select add resource icon from top 3.from Addresouce two optios is there(a.jasperserverreport and b. from others-> jrxml file) here(i think) option b is not having Customization. i chose Jasperserver report from Addresource icon 4. a.Naming: login_cssi b.JRXML*(here two options one is file system and another one is from repository) i try use file system it (i add jsp file) error is: parsing error i try use seconde option (from repository)but i dont have any Jrxml file(i had onely jsp file) how can move from this step? I think last option is Customization. could u please inform to me the process,how add jsp file to jasperserver? BestRegards shiva

HI every one, I am having .jsp file,once i deployed my .jsp file into /WEB-INF/JSP folder, Question :- how can i possible to view (my jsp page) from jasperserver? (i mean how can i link with jasperserver ) Thanks in advance Bestregards shiva

Dear Mahi, Thanks for ur quick reply..... If i deploy the .jsp file into WEB-INF/JSP folder,can i possible to view from jasperserver browser? Bestregards shiva

Dear Members, Now i am trying to load(deploy) .html/.jsp page into jasperserver, i am unable to load (.html/.jsp) Because i followed deploy a file like .jrxml. Can u help any one,how to deploy .html / .jsp page into jasperseever? Thanks in Advance Bestregards shiva