fostermj

Hello - I'm a newbie and, The following MDX query works in my Jasper Workbench, but not in JasperServer (yes, I've reloaded everything too). SELECT {[Measures].[Quantity], [Measures].[sales]} ON COLUMNS, {([Channel], [Product Category])} ON ROWS FROM [Channels] The following is my Schema - Can someone find my error? - <Schema name="MJ2">- <Cube name="Channels" cache="true" enabled="true"> <Table name="PIECE_TYPE_AGG1" schema="CHRIS" />- <Dimension type="StandardDimension" foreignKey="ORDER_TYPE_ID" name="Channel">- <Hierarchy hasAll="true" allMemberName="All Channels" primaryKey="ORDER_TYPE_ID"> <Table name="ORDERS" schema="CHRIS" /> <Level name="Channel Descr" column="ORDER_TYPE_ID" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> </Hierarchy> </Dimension>- <Dimension type="StandardDimension" foreignKey="PROD_CATEGORY_ID" name="Product Category">- <Hierarchy hasAll="true" allMemberName="All Prod Categories" primaryKey="PROD_CATEGORY_ID"> <Table name="PRODUCT_CATEGORY" schema="CHRIS" /> <Level name="Prod Category Descr" column="DESCR" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> </Hierarchy> </Dimension> <Measure name="Quantity" column="QTY" aggregator="sum" visible="true" /> <Measure name="Sales" column="SALES" aggregator="sum" visible="true" /> </Cube> </Schema>

Hi - I am new at this so bear with me if my questions appear simple. When I make a change to a dimension in my schema and then try to view the changes in JasperServer, they are not there. Am I supposed to reload my schema every time I change it? For example, rather than displaying the product_id I want to display the product description and I change my dimension accordingly, it continues to show the id rather than the description. The last time I made changes we had to reboot the JasperServer before we could see the changes. What am I doing wrong? Thank you.

Hello: We have just downloaded JasperETL and are trying to connect to an Oracle XE database. I have filled out the information (i.e., driver, server, etc.) and, when I click the Check button I receive no messages - it does not say I have connected successfully or not connected at all. The Finish button is still enabled so I have also tried that - to no avail. I feel my question is so basic I am embarrassed to post it, but posting in nonetheless I am. If anyone has any ideas, your help would be greatly appreciated. MJ