Profile

Marek Tomko

Accenture CAS GmbH

Contact Details

Accenture CAS GmbH

My Content

1 to 17 of 17 total

RE: Different pagination for different export types in PRD

Posted By Marek Tomko 08-17-2022 02:16
Found In Library: Pentaho

RE: Different pagination for different export types in PRD

Posted By Marek Tomko 08-17-2022 02:16
Found In Community: Pentaho \ view thread
I got an answer from Hitachi support: Click of the sub-report on the details band. Find the pagebreak-before option and click the green plus(+) icon to add a open formula for the pagebreak-before option. Add the below formula. The below formula states that if the report is exported into a PDF format ...

Different pagination for different export types in PRD

Posted By Marek Tomko 08-15-2022 08:58
Found In Library: Pentaho

Different pagination for different export types in PRD

Posted By Marek Tomko 08-15-2022 08:51
Found In Community: Pentaho \ view thread
Hello, I created static report with Pentaho Report Designer using 3 subreports. For second and third subreport I set "pagebreak-before" option to 'true', to have each of them on the new page. It influences PDF and also Excel output. See attached screenshots. Is it possible to set page break only for ...

Dynamic authentication token in KTR Rest Client

Posted By Marek Tomko 05-02-2022 10:47
Found In Community: Pentaho \ view thread
Hi, We provide Authorization HTTP Header with the value Basic and the Base64 encoded username and password in Rest Client in KTR file. In examples I see only hardcoded values of authentication token. Is it possible to get that dynamically according to user logged (through PUC) in Pentaho server? I have ...

RE: Cannot import KTR / KJB files to Pentaho repository

Posted By Marek Tomko 05-02-2022 09:15
Found In Egroup: Pentaho \ view thread
Hi Andrew, We already included ktr type in ImportHandlerMimeTypeDefinitions.xml before, but it did not help. I already mentioned in my previous post, that "I also tried to zip it and upload, but unfortunately, it is same." I also checked "(serverurl:port)/pentaho/api/repo/files/:public/tree" after ...

RE: Cannot import KTR / KJB files to Pentaho repository

Posted By Marek Tomko 04-12-2022 02:03
Found In Egroup: Pentaho \ view thread
Hi Andrew, Yes, I'm logged  under user with administrator role. Same thing happens in any folders. As I mentioned, the other files are OK to upload and we have no issues with prpt, xanalyzer, cde, cda, cdfe files. I also tried to zip it and upload, but unfortunately, it is same. Any other ideas ...

Cannot import KTR / KJB files to Pentaho repository

Posted By Marek Tomko 04-11-2022 11:07
Found In Egroup: Pentaho \ view thread
Hello, I'm trying to upload ktr file on the Pentaho server using PUC. After the upload I do not see the KTR file uploaded even I marked the option "Show Hidden Files". Only thing I see in log is: ("zeitstempel":"2022-04-11T14:22:28.501Z","level":"INFO","thread":"ajp-nio-0.0.0.0-39153-exec-10","mdc ...

Pentaho PDI - Keycloak Authentication

Posted By Marek Tomko 04-06-2022 09:22
Found In Egroup: Pentaho \ view thread
Hi all, We are using PDI KTR file with REST client step to consume json from API. We are trying to authenticate user through Basic Authentication. We set values in Generate Rows step and use them in REST client in Headers. We do not set anything in Authentication tab. It does not work for us. ...

RE: Optional Data source for Pentaho Analyzer

Posted By Marek Tomko 12-08-2021 11:59
Found In Egroup: Pentaho \ view thread
Thank you Halsey! I also created thread in Pentaho community. How do I close this one? ------------------------------ Marek Tomko Systems Engineer Accenture CAS GmbH ------------------------------

RE: Optional Data source for Pentaho Analyzer (Drag & Drop solution)

Posted By Marek Tomko 12-08-2021 09:36
Found In Egroup: Pentaho \ view thread
So it looks that we need to use for example PDI to tranfer data from Cassandra or Rest Endpoint and store them to Analyzer supported JDBC solution. ------------------------------ Marek Tomko Systems Engineer Accenture CAS GmbH ------------------------------

Optional Data source for Pentaho Analyzer (Drag & Drop solution)

Posted By Marek Tomko 12-07-2021 04:46
Found In Egroup: Pentaho \ view thread
Hello, We use Pentaho Analyser reports, which use cubes defined in Mondrian schema connected to Ignite DB. I'd like to know, what other kind of data source options we have for Analyser Reports. Can we use for example Cassandra or Rest Endpoint directly? PS: Should this question be here or do ...

RE: Pentaho Static Report using Json through Rest Point

Posted By Marek Tomko 05-24-2021 13:58
Found In Community: Pentaho \ view thread
Im sorry that a I have to say this, but I got a feeling in general that Pentaho is dead tool. Especially when I compare it to other ones with much better community support. I see many questions here without answers.

Pentaho Static Report using Json through Rest Point

Posted By Marek Tomko 05-10-2021 20:09
Found In Community: Pentaho \ view thread
Hi everyone,   I created Static report by using Report Designer. We use PDI transformation file to retrieve JSON through the Rest Client.   This is how it should work:   You open the report on Pentaho Server You enter the year as a parameter Year parameter will be used in Rest Point URL. You will receive ...

Pentaho Static Report using Json through Rest Point

Posted By Marek Tomko 05-10-2021 20:09
Found In Library: Pentaho

RE: Percentile in Analysis Report and MDX Datasource in Ctools CDE Dashboard

Posted By Marek Tomko 12-08-2020 10:59
Found In Community: Pentaho \ view thread
Hi,   I attached some sample data with sample schema. For CDE Im trying to implement simple script:   WITH MEMBER  [Measures].[m1avgCpu-99p] as Percentile([Time].[Time].MEMBERS, [Measures].[m1avgCpu], 99) SELECT ([Measures].[m1avgCpu],[Measures].[m1avgCpu-99p]) ON COLUMNS, NONEMPTYCROSSJOIN([Date].[ ...

Percentile in Analysis Report and MDX Datasource in Ctools CDE Dashboard

Posted By Marek Tomko 11-30-2020 16:28
Found In Community: Pentaho \ view thread
Hi,   Is there any way to calculate and visualise Percentile in Analysis Report and using MDX data source in CTools CDE Dahsboard (e.g. Charts)?   Thanks and regards,   Marek #ReportingandAnalytics #Pentaho #Ctools