arunsinghal01

Hi, I have a requirement from display perspective. I want to hide the unnecessary multilevel caption name from an Analysis view. For e.g. say i have a Time dimension on column side. And it has a hierarchy like "All Periods", Year, Month, Day and i am at month level. Now in an Analysis view it will show headers like Measures Measure Name (Usage Count) Period All Periods 2010 Apr-10 as shown in first image attached. But i want to show only following Measures Name (Usage Count) Apr-10 as shown in second image attached. How can i achieve this? Another way of asking this question is how can i display only measure name and last selected level of a hierarchy on column side of an Analysis View?

Hi I am getting a problem while using ireport when i load image through jrxml and give the path of image in image expression. image get compiled through the given path,but on run time when it generates a html file which takes the image from another generated folder. how can we customize the output folder according us. i am giving example like i ve folder structure usr/up.gif . this up.gif is using while complie time taking image in jrxml.where jrxml file name is sample.jrxml but when i get run time preview of html ,it creates folder sample.html_files and the html file name is sample.html which takes image from newly created sample.html_files folder.i want this sample.html_files folder as image name folder. how can we do this through jrxml file. Thanks

Hi All, I have a dimension with parent child hierarchy as shown in code block. The issue i am facing is if i have a filter on parent child dimension then drill through table does not apply that filter instead it shows all the data for that dimension. Here is an example. Now suppose i have 4 rows in npg_page_type_view table id display_name parent_id 19 HTML 100 20 PDF 100 21 XML 0 100 Total 0 Now suppose in my fact table i have following records id count 19 2 20 3 21 1 Following is my analysis view. Total (HTML and PDF) - 5 HTML - 2 PDF - 3 XML - 1 Now if i add filter(say Total) on this analysis view using OLAP cube. Then my analysis view shows the following. Total (HTML and PDF) - 5 Upto this point everything works fine. Now if i click on 5 (to view drill through table) It shows me data against all page type i.e. HTML, PDF, XML but as per filter it shold show only HTML and PDF. Is it an issue or am i doing something wrong here? Please help me. Code: <Dimension type="StandardDimension" name="page_type_d" caption="Page Type"> <Hierarchy name="page_type_h" hasAll="true" allMemberName="all_page_types" allMemberCaption="All Page Types" primaryKey="id"> <Table name="npg_page_type_view" alias="pt"> </Table> <Level name="Page Type" column="id" nameColumn="display_name" parentColumn="parent_id" nullParentValue="0" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" caption="Page Type"> <Closure parentColumn="parent_id" childColumn="page_type_id"> <Table name="dim_page_types_closure"> </Table> </Closure> </Level> </Hierarchy> </Dimension>

Hi Gaby38, Thanks for the reply. I have also tried it with a separate dimension table as shown in code block. I have 236 million records in my fact table and 2500 records in date dimension table. Overall i have tried 3 scenario given below. 1. All year, month, day column in fact table as integer type. In this case my query takes 1.5 minute. 2. But i need month name instead of month number so i made one more column in my fact table as month_name. In this case it is taking 3.5 minutes. 3. Then i tried separate date dimension table as u suggested. But this case is also taking 3.5 minutes. As i am using Infobright i asked this query on Infobright forum and there Mr. David suggested me to use date dimension as well as month integer column in fact table to make filter on fact table. But i my problem is how can i define dimension table as well as filter in an OLAP schema. The code for OLAP schema is given in code block. Please help me how can i define both dimension table and filter column in fact table in OLAP schema. Thanks, Arun Code:<Hierarchy name="period_h" hasAll="true" allMemberName="all_periods" allMemberCaption="All Periods" primaryKey="date_id"> <Table name="dim_period" alias="dp"> </Table> <Level name="Year" column="year_name" type="Integer" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> </Level> <Level name="Month" column="month" nameColumn="month_name" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"> </Level> <Level name="Day" column="day" nameColumn="day_name" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never"> </Level></Hierarchy>

Hi, I am trying to optimize month column in my fact table. If month column is integer type then following query is generated by jasperserver which takes 8 sec and 313 milliseconds. This is fine. select `fd`.`date_month` as `c0` from `fact_details` as `fd` where (`fd`.`date_year` = 2010) and `fd`.`date_month` = 1 group by `c0` order by `fd`.`date_month` ASC; But i want to display String value for month field like ‘Jan’,‘Feb’ etc. Therefore i added one more column month_name varchar field in my fact table. Now jasperserver generates following query which takes 1 minute and 59 seconds. select `fd`.`month_name` as `c0` from `fact_details` as `fd` where (`fd`.`date_year` = 2010) and UPPER(`fd`.`month_name`) = UPPER(‘Jan’) group by `c0` order by `fd`.`month_name` ASC; Now if i compare both the query then the difference is marked in red. This is due to UPPER function in the query. Now if i run the second query without UPPER function as show below it takes 8 seconds and 547 milliseconds which is equivalent to first query. It means UPPER function is taking maximum time. select `fd`.`month_name` as `c0` from `fact_details` as `fd` where (`fd`.`date_year` = 2010) and (`fd`.`month_name`) = (‘Jan’) group by `c0` order by `fd`.`month_name` ASC; Please suggest me how should i optimize this. 1. Can i avoid UPPER function so that jasperserver does not generate it for varchar fields? 2. Is there any alternate way to handle the same scenario?

Hi I have following data in one of my dimension table. Id display_name category 1 A alpha 2 B alpha 3 C alpha 4 001 count 5 002 count Now in my analysis view i want to see data with alpha category only. How can i implement this in OLAP schema. Neither i want to use database views nor I can change this table data. Can anybody help me? Thanks in advance, Arun Post Edited by arunsinghal01 at 02/01/2010 12:41

Hi I want to disable OLAP cache permanantely. Is there any property which i can use to disable OLAP cache permanantely? Thanks, Arun Post Edited by arunsinghal01 at 02/01/2010 11:37

Hi, When i click on a dimension / measure inside change data cube then it displays all the available options and a checkbox in front of each option. I am also able to group them alphabatically if the list is large. Now my question is Can i make a exact search or pattern search instead of manually searching. For e.g. if i have a list of 1000 institutions say I1 to I1000 and now i want to select only I305. Can I make a serch for I305 instead of going down and selecting it. I am searching for this kind of functionality. Is it available in jasper soft? Post Edited by arunsinghal01 at 10/01/2009 05:34

Hi Daryl, I am having the same problem. I tried to access http://jasperforge.org/sf/go/artf1762?nav=1 but this is not working. Can you please send me that jar at arunsinghal01@gmail.com asap. Thanks, Arun