formatting a property value in dimension in SQL

[Former Member]

I am new to BPC 7.5  sp8 Microsoft version 2008 R2. I would like to format the date from mm/dd/yyyy  to yyyy-mm-dd in a member dimension for all members straight in SQL . I tried it and processed the cubes but the record remains the same when I view it from the front end.In TSQL I can easily update the member dimension field with a single update statement

e.g  from 1/8/1984 to 1984-01-08 00:00:00

Doing this from "Manage Dimension members" from the Application is rather long.This update is for 14232 entries. How is this possible because?

What is the sequence of steps I need to follow in SQL so that the update is complete and the application recognizes it?

[Former Member]

Hello Dludlu,

In MS you must use front end (manage dim members) to update Dimension properties than writing down TSQL etc. These are nothing but the xlsx file and procssing these files update the different table in backend like MBR tables.

Thanks,

Rohit Sharma

[Former Member]

Thanks Rohit for the response.The real challenge is that the number of records in question is 14242.