Hi,

In SSAS2000 I used the folowing formula in a SSDS2000 view:

LEFT (CONVERT (CHAR; GETDATE(); 105); 11) + CONVERT (CHAR; GETDATE();
108)

Now in SSAS2005 I would like to have the same working in both Data
Source View and OLAP Cube / Dimension

I tried to have the following formulas in Data Source View:
1. Getdate()
2. CONVERT (CHAR; GETDATE(); 105)
3. LEFT (CONVERT (CHAR; GETDATE(); 105); 11) + CONVERT (CHAR;
GETDATE(); 108)

1. Getdate() shows the correct date but press ok on Data Source View
ends in an error and it can't ber saved.
2. CONVERT (CHAR; GETDATE(); 105) shows the correct date in Data Source
View but it is not accepted in the OLAP Cube
3. LEFT (CONVERT (CHAR; GETDATE(); 105); 11) + CONVERT (CHAR;
GETDATE(); 108) shows the correct date in Data Source View but it is
not accepted in the OLAP Cube

I only want to show the date + time of data processed in the OLAP Cube
in an OLAP Report.

Any ideas / comments to have this working. What is the email address or
message board of Microsoft to report any errors, questions, etc
regarding the new SQL Server 2005 components: SSDS, SSAS, SSIS, SSMS,
etc ?

Regards, Marco

I had to use Now().

"Marco" wrote:

Is now() working within SSAS 2005 instead of getdate() ?

I will check also with our BI/OLAP database. If I remember well now()
is showing the local date?

Regards, Marco


SAM schreef:

Hi,

now() is not working. errors in the ssas2005 view.

I did install ssas2000 and do a migrate and now i see why there was
always an error.

You may not use CONVERT (CHAR(11); GETDATE(); 105) + CONVERT (CHAR;
GETDATE(); 108) as key of an attribute of a dimension in SSAS2005. This
is only working as name. Adding a new computed field in the ssas2005
view: CONVERT (CHAR(11); GETDATE(); 112) and use it as key for the
dimension attribute and now it is working ok.

Any idea if there is somewhere on internet a document with time/date
handling issues for SSAS2005 ?

Regards, Marco


Marco schreef: