Restriction data entry for input ready query

[Former Member]

Dear All,

I have an input ready query with two structures for rows and columns.

However, I have set one of columns' structure's member as "data can be changed with planning functions", i'm able to enter data for that column. When i execute save function, entered valus are being disapperaed.(not benig written to the cube)

But i want to restrict data entrance for that column. (Like display functionality in BPS)

I know i can protect fields with excel functionality, but we are using web environment.

How can i resolve mentioned issue?

Thanks

Alkan

[Former Member]

Hi,

If you can write macros in web interface, this functionality can easily be achieved through a simple macro.

For that particular cell,

sample code:

cells(row,column).disable = True

Regards,

Bindu

[Former Member]

Hi Bindu,

Thanks for your quich answer.

In web environment, i think i need to use WEB API.

Do i need to write java script? Or is there any particular class to manage the properties of the cells?

BR

Alkan