How to change the date format on SSAS 2012

sql-server ssas ssas-2012
SQL.injection picture SQL.injection · Mar 20, 2014 · Viewed 14.4k times · Source

I have deployed an SQL Server 2012 on a Windows Server en-us.

Now my dates on Analysis services are in the American format (MM/dd/yyyy). the company is not American, therefore I would like to change it to yyyy-MM-dd or dd-MM-yyyy, how can i do it?

Everything seems to be properly configured, however, SSAS is refusing to output the dates in the desired format :(

On excel:

American dates on Excel

On cube browsing: On cube brosing

On dimension browsing: enter image description here

Dimension seems to be properly configured on SSAS: SSAS dimension configuration

Query on SQL Database engine:

Query on sql engine

SSAS properties SSAS properties

SQL Server Database engine properties Database engine properties

Windows server regional settings Server regional settings

Answer

ASNAOUI Ayoub picture ASNAOUI Ayoub · Mar 20, 2014

A few month ago i was enduring the same problem with the date, i thought the issue was comming from SSAS but i was wrong...

So i totally changed my dimension table with a new table containing all date format, so now i can use any format that i want...

http://www.codeproject.com/KB/database/647950/figure1.png

You can find how to create it in this link:

http://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-Data-Wareho

Related questions

SQL Server 2012: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000

I am using Analysis services in Microsoft SQL Server 2012 on Windows 7. I tried to create Mining models and process it. I am getting the following error while processing it. OLE DB error: OLE DB or ODBC error: Login failed for …

Read More
SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax properly in the case below. I'm using SSAS 2005 on MS SQL Server 2005 and would like to query my cube and …

Read More
SQL Server Analysis Services - Do I have it?

Hi I have access to SQL Server at work and I've heard some interesting things that can be done with SQL Server Analysis Services. How do I know whether analysis services is running? Is it installed by default on the …

Read More