logo
down
shadow

How do I do my Pentaho Report take the Excel datasource file along to BA/BI Server?


How do I do my Pentaho Report take the Excel datasource file along to BA/BI Server?

By : user2948395
Date : November 14 2020, 04:51 PM
seems to work fine This one's tricky, as you need to refer to the file inside the PRPT (which is basically a ZIP file). Here's a procedure that worked for me:
1) Add the Excel (or whatever) file as a Resource in Pentaho Report Designer (PRD). For my test, I used the customers-100.txt file from the PDI samples, and named the resource "customers-100". Then I saved the report as prd_test.prpt.
code :


Share : facebook icon twitter icon
Pentaho - Reporting Tool - Does the .prpt file (report template file) contains datasource information too?

Pentaho - Reporting Tool - Does the .prpt file (report template file) contains datasource information too?


By : Sydney Döffert
Date : March 29 2020, 07:55 AM
it helps some times Nope. The data source can be stored in the prpt, but it can be passed to the report too. And the usual way is to simply use JNDI so that you can deploy the same report, to multiple test/dev/production environments.
You'll probably get better quicker answers from the forum. forums.pentaho.org
Why would a report work in Pentaho Report Designer but not in BI Server

Why would a report work in Pentaho Report Designer but not in BI Server


By : Neha Jobanpurtra
Date : March 29 2020, 07:55 AM
With these it helps When you define the parameter for your report please uncheck the radio button of validate parameter and then again publish it to BI server. sometimes validating parameter causes problem in BI server.
I hope this will help for you.
Pentaho report which contains more than 7 connections are not working in pentaho DI server

Pentaho report which contains more than 7 connections are not working in pentaho DI server


By : James Gundy
Date : March 29 2020, 07:55 AM
this one helps. I am new to pentaho. Recently i created a job which generates some report. I am using JNDI connection in the report(.prpt). If I am using more than 7 connections inside a report, it will fail to generate report but it's working smoothly with reports which has lesser connections. , It was actually due to issue in data factory.
Steps to do:
Pentaho Server: Changes made in the report does not reflect in the Pentaho Server (User Console)

Pentaho Server: Changes made in the report does not reflect in the Pentaho Server (User Console)


By : user1267459
Date : March 29 2020, 07:55 AM
it fixes the issue I have found the answer. We need to open the Pentaho User Console and then
Click on Home -> Click on Administration -> Under Users & Roles, click on '+' next to Users -> Create a User and give the roles as Business Analyst (any role will work)
Pentaho Report Designing issue with excel

Pentaho Report Designing issue with excel


By : Kashif Zia
Date : March 29 2020, 07:55 AM
it fixes the issue There is a separate format for PDF like A4,A4_Extra and A5. So that you can get what you have selected.There is no specific format for Excel like PDF,So You should use ruler to avoid such merged cells in excel(You have to do separately for excel)
Related Posts Related Posts :
  • Excel - VB - Re-ordering /Renaming columns
  • "Overload" F9 (or shift+F9) in Excel spreadsheet with VBA function?
  • ShowAllData method of Worksheet class failed
  • VBA If cell is under a certain length, highlight and display message
  • VBA: Unable to get the Match property of the WorkSheet function class
  • Highlighting the second and more duplicate rows in excel but not first occurrence?
  • Excel add- in focus not returned to the active sheet
  • How to restrict VBA code to a specific worksheet?
  • How to insert column name in the destination table in ssis?
  • Insert text into the background of a cell
  • how do I generate random timestamps in Excel
  • VBScript Opening folder to convert csv to xls
  • Creating a VBA Refresh Macro in Smart View for Oracle
  • Excel Performance issues with countif on multiple rows
  • excel vba http request download data from yahoo finance
  • Excel Vba Loop , not running properly
  • Efficiently hiding / unhiding many (+500) rows in Excel VBA
  • Excel's Find function; Exceptions over values
  • reading data from an excel sheet in perl
  • Using Webservice function in Excel to pull "Next Earnings Date" from Yahoo Finance using Yahoo API
  • Three And (&)'s into an if statement VBA for Excel
  • Certain fractions being calculated in excel 2013
  • Excel formula to find sum of difference
  • countfis or sum if array to work out if given time is between the value of two columns
  • Error in Date Cell in CSV
  • Syntax while trying to include The multi-part identifier [°C] in command text
  • How to find day of the week from known date and month but variable year
  • Modify Marker Transparency with Excel VBA
  • Excel tricky formula
  • Loop Though All UDF Names in Project
  • Searching for function usage in Excel VBA
  • Convert from list to flat CSV with modified data
  • Count how many words from a list appear in a cell
  • Insert Missing Years between 2 years
  • Creating hierarchical sequence in Excel using several functions in formula
  • On Error GoTo statement is still executing although there is no error generated
  • Find last digits with IF
  • Use Excel VBA to find column matches & merge based on the values of two other column
  • PowerPivot not sending Authorization header in Basic Authentication to OData Svc
  • Vlookup not working with text search
  • Paste value from a Userform to a Excel Sheet
  • Excel 2010 Macro to compare two columns for finding the matched value
  • #VALUE error when dealing with long string in UDF in VBA(excel)
  • Refer to a cell in another worksheet by referencing the current sheet's name
  • VBA Excel 2007 : Need to loop copy and loop count number except zero every row above
  • Excel: Conditional probabilities of winning a tiebreaker game
  • How to find groups of individuals who attended multiple events together?
  • Using DateTime when referencing a cell with SUMIFS()
  • VBA Copy & Transpose Data Range
  • Huge excel file... any advice?
  • Looped macro to create a new sheet, rename it, add data from the web, then loop back through until complete
  • copy paste of tab delimited text results in strange formatting in Excel?
  • Excel user defined function: Nth_Occurence
  • Excel ActiveX Button is clickable, but does not work
  • Array Formula Conditional Count
  • YEAR() fitting to WEEKNUM(...,21) in Excel
  • Macro that follows a link and downloads the table into a new sheet
  • How to Concatenate multiple columns if not empty
  • Excel - List all the combinations of two words from one list, in two other columns
  • shadow
    Privacy Policy - Terms - Contact Us © ourworld-yourmove.org