From another thread I read that ReportPortal doesn't support formatting on numerical values (rounding, etc)...but how is this handled on datetime values?
I don't want to see T-SQL format YYYY-MM-DD 00:00:00.000 -- I just want to see the date MM/DD/YYYY.
OLAP report supports formatting of dates and numbers for measure via calculated measures. OLAP report does not support formatting of dimensional member names. You would have to do this in a data source view like
quote:[i]Originally posted by admin[/i] [br]OLAP report supports formatting of dates and numbers for measure via calculated measures. OLAP report does not support formatting of dimensional member names. You would have to do this in a data source view like
select CONVERT(varchar, GetDate(), 101) as MyDate
Hmmm, I'm sorry. I'm confused. Are you saying within SSAS I can format date members? Datetime columns are converted to YYYY-MM-DD 00:00:00.000 members when the cube is processed. I'm unaware of any way to change this and have always formatted the date in the report setup when using SSRS. ReportPortal doesn't have this capability? The above example is SQL--which I can do--but are you saying I have to set something new up in SSAS just to format a date member?
Report Portal
Date Formatting
Posted - 02/24/2012 : 10:15:50
