I am trying to change the Custom Member Formula of a cube
(created by SSABI).

The custom formula pane is greyed out and I cannot make
any changes to the formula.
According to BOL, the dimension needs to be write-enabled.

Unfortunately, the Write-enabled combo box in the
dimension editor is also grayed out. On the other hand,
the Changing combo is enabled, so I was able to make the
dimension a Changing dimension. However, the Write-enabled
combo remains greyed out.

How can I make my dimension write-enabled??

I have SQL Server Analysis Services 2000 sp3a, Enterprise
Edition running on Windows 2000

Thanks for any help.

Maybe your dim isn't parent/child -- only parent/child dims can be
write-enabled.

No matter. Simply edit the formula in the SQL table; this need not occur
within Analysis Mgr. Then process the dim.

tom @ the domain below
www.tomchester.net


"James" <news (AT) att (DOT) com> wrote

Hi James,

Thanks for your post. I agree with Tom that only parent-child dimension can
be write enabled. To make a dimension write-enabled, please set the
Write-Enabled dimension property in the Properties Pane (Dimension Editor
Data View).

For more information regarding making dimension write-enabled, please refer
to the following article on SQL Server Books Online.
Topic: "Properties Pane (Dimension Editor Data View)"

To enable the Custom Member Formula pane, you still need to set Customer
Member property of the dimension to True and process the cube again which
contains this parent-child dimension. When you process the cube again,
please click the "Incrementally update the shared dimensions used in this
cube" option.

For more information regarding Customer Member property, please refer to
the following article on SQL Server Books Online.
Topic: "Define Custom Member Column Dialog Box"

Also, I would like you to check to see the suggestions in the following
article:

Write-enable dimension property not visible

http://groups.google.com/groups?hl=e...readm=eDaWOdj%
23CHA.1156%40TK2MSFTNGP12.phx.gbl&rnum=1&prev=/groups%3Fq%3D%2522custom%2Bme
mber%2Bformula%2522%2Band%2B%2522write-enabled%2522%26hl%3Den%26lr%3D%26ie%3
DUTF-8%26oe%3DUTF-8%26selm%3DeDaWOdj%2523CHA.1156%2540TK2MSFTNGP12.p hx.gbl%2
6rnum%3D1

Analysis Server Questions

http://groups.google.com/groups?hl=e...readm=3bcf9aef
%241%40usenetgateway.com&rnum=2&prev=/groups%3Fq%3D%2522custom%2Bmember%2Bfo
rmula%2522%2Band%2B%2522write-enabled%2522%26hl%3Den%26lr%3D%26ie%3DUTF-8%26
oe%3DUTF-8%26selm%3D3bcf9aef%25241%2540usenetgateway.com%26 rnum%3D2

How to create a custom member formula in a write-enabled dimension
http://msdn.microsoft.com/library/de...us/olapdmad/ag
htdimopt_8626.asp

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Michael,

Thank you for your suggestions, but the Write-dimension
combo in the properties pane is grayed out. I cannot write-
enable the dimension in the property pane, this is exactly
my problem.
I am sorry if my post wasn't clear enough.

The post you are referring to solves the problem of
somebody who isn't running the Enterprise edition of
Analysis services, and we are running the Enterprise
edition here.

So yes, I need further assistance.

Should you have any more ideas, I would be pleased to hear
from you again.

Thanks for the suggestion. I'm going to give it a try.
At first, I tought your suggestion was to edit the
OlapObjects table of the Analysis Services Repository.
I wasn't too keen on that, but then I realized that the
custom formula was in the Dimension table of the
relational database. Exactly as you suggested, I didn't
think it was that simple.
Thanks a lot, it looks like this will solve my problem.

Hi James,

Thanks for your response. It is strange that the Write-enabled property is
not grayed out on my side. Currently, how is this issue going on your side?
Does Tom's suggestion solve your problem? If not, it would be great if you
could provide the detailed steps on how you check and see the Write-enabled
property on your side so that I can narrow down this issue by attempting to
reproduce the situation on my side.

Also, did you view the Write-enabled property via the Cube Editor view? If
so, the property is also grayed out on my side. I can change the
Write-enabled property via the Dimension Editor View. The following steps
are used to set the Employees dimension in the FoodMart 2000 sample
database.

(Right click the Employees dimension in the Shared Dimensions folder
-->Click Edit...* command -->Check to see the Write-enabled property on the
Advanced tab in the Property pane).

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.