CODEWITHSUNDEEP
pentaho
Indoordinosaur
Indoordinosaur

Reputation: 139

Pentaho Analysis Report date format

I'm fairly new to Pentaho. I have set it up on a linux server and am trying to build an analysis report in the web-browser accessed user console. One of my data sources is a date in the format yyyy-MM-dd. When this is put into a report it displays an additional 00:00:00.0 timestamp. notice the formatting under Provider GL Period Name

I have searched around the options in the Analysis Report editor. I have also edited the Data Source Model so that that dimension is recognized as a time dimension along with its source format.

Any help is greatly appreciated, thanks!

Upvotes: 0

Views: 1780

Answers (2)

Kit Guial
Kit Guial

Reputation: 11

You can change the field type from Date type to Text type.

1. Insert a new text field
2. Go to Structure > Attributes
3. Edit the value of the field by choosing your Date data

The new output will just be e.g. 2017-03-12

Upvotes: 1

shzyincu
shzyincu

Reputation: 419

I had similar problem as well. What I did I added a text field and clicked the plus button for formula from value field. Used function =LEFT([your-date-field], 10)

This will remove the timestamp.

Upvotes: 1

Related Questions