[Working with Drill through option in OLAP]

Hello,

 

I am able to start and work with OLAP Views. I am able to create a simple OLAP View where on clicking one item, I get all the child items within that.

 

But so far I am not able to add drill through feature to that OLAP View. I know there is something which has to be linked to the main OLAP View in the XML file(Cube). But so far I am not able to make out what it is. I am still trying on that. Can anyone just give me a detailed information on this, please?

 

Thank you,

Mohan.

[Creating schema for OLAP]

Hello,

 

I am trying to work on OLAP Views in JasperIntelligence.

So to etablish a Mondrain connection, we need to create one schema for that. I just went through the sample Schemas given (FoodMart xml files). Is there any tool to create a schema? Or do we need to manually write the XML File? Can anyone please give me step by step guidance in creating a schema to impliment the OLAP view, please?

 

Thanks in advance,

Mohan

[Can anyone help me out ..]

The report fails here. I changed the JRXML file the same way as you have suggested. There might be something wrong from my side. I am not able to make out. The error is:

 

it.businesslogic.ireport.ReportClassLoader@1757423 net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. com.jaspersoft.jasperserver.api.metadata.user.domain.User cannot be resolved to a type value = (java.lang.String)(msg("{0}", ((com.jaspersoft.jasperserver.api.metadata.user.domain.User)parameter_LoggedInUser.getValue()).getFullName())); <-------------------------------------------------------> 2. com.jaspersoft.jasperserver.api.metadata.user.domain.User cannot be resolved to a type value = (java.lang.String)(msg("{0}", ((com.jaspersoft.jasperserver.api.metadata.user.domain.User)parameter_LoggedInUser.getValue()).getFullName())); <-------------------------------------------------------> 3. com.jaspersoft.jasperserver.api.metadata.user.domain.User cannot be resolved to a type value = (java.lang.String)(msg("{0}", ((com.jaspersoft.jasperserver.api.metadata.user.domain.User)parameter_LoggedInUser.getValue()).getFullName())); <-------------------------------------------------------> 3 errors

 

swood wrote:

You are not giving enough information here. As I asked: "Does your report fail? Or just come up with a blank user?" Sherman JasperSoft

[Can anyone help me out ..]

Hello Sherman,

 

I tried the putting the piece of code you had sent. For me it didn't work. My be I was wrong some where. So can you please suggest me more elaborately about how to get the user_name on the report. Iam getting it in the JasperIntelligence environment. But after exporting the same report to pdf, html,... Iam not able to get that. Can you please help me in more detailed manner, please?

 

Thank you,

Mohan.

 

swood wrote:

Our unit tests export the user name to all formats. Does your report fail? Or just come up with a blank user? In the JRXML, we do things like: Code: <textFieldExpression class="java.lang.String">msg("{0}", $P{LoggedInUser}.getFullName())</textFieldExpression>     Sherman JasperSoft

[Customizing JasperIntelligence home page]

Hello,

 

Is there any option of customizing JasperIntelligence homepage? For example, in the JasperServer home page, while viewing the report, can I put my own text and images in the place of the title 'JasperIntelligence'? Hope my question sounds silly, but I got a doubt. If anyone has a solution please let me know.

 

Thank you,

Mohan.

[Can anyone help me out ..]

Hello Sherman,

 

Thanks a lot for the solution.

 

I am getting the user name displayed in the JasperIntelligence environment. But when I export the same report to html or pdf formats, I am not able to get the username on the report which is in html or pdf format. Can I get the user name displayed on the corresponding html or pdf?

 

Please can you give some solution for this?

 

Thank you so much,

Mohan.

 

swood wrote:

In your JRXML that will run in JasperIntelligence, add: <parameter name="LoggedInUser" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User"/> All reports get passed this parameter. From this LoggedInUser object you can get: Code: public String getUsername(); public String getFullName(); public String getEmailAddress(); public boolean isExternallyDefined(); public boolean isEnabled(); public Set getRoles();     Sherman JasperSoft

[Can anyone help me out ..]

Hello,

 

I got started with JasperIntelligence reports. I am able to work with the formats, groups, totals etc... But I would like to know is there any option of displaying the user_name(the person who has created the report) on the report. If anyone has worked with it, please give an example.

 

Thanks in advance,

Mohan

[Small question about creating criteria page]

Hello,

 

I am able to create the criteria page and link it to the report. It works well without any problem. I have a doubt. Assume that I have 2 reports. One report for displaying data, and one report for showing the chart. Can I have the option of choosing either report or the chart, in the criteria page? As far as I tried, I felt it is not posssible. But I think, someone might have tried this option. If anyone has tried it, please can yo u let me know is this possible or not. If yes, can you let me know how?

 

 

Thanks a lot,

Mohan.

[Criteria page in JaspreIntelligence]

Hi Thanks a lot. I am able to get the values from the database.

 

rx7haze wrote:

When you add the input control specify the type as single select query.

[Criteria page in JaspreIntelligence]

Hello,

 

I have a criteria page with an input control(dropdown list), which links to the report. So when I select a value from the drop down, I get the report with the data matching the criteria. So far I am able to hard code the values into drop down list. Is there any way I can get the values from the table into the drop down list? Can anyone please help me?

 

Thanks in advance,

MohanRao.