Use of No Data in access table?

[Radhika]

Hi All,

I am not sure as how to use 'No Data' access level in Access table. Can anyone explain to me the usage of 'No Data' Access level in access table?

What is its affect if i include in access level along with 'Hidden', 'Read' and if not included.

If possible can anyone give me the scenario, when should some one has to apply 'No Data'.

Pleaseeeeeeeeeeeeeeee!!!!!!

Thanks in Advance.

Regards,
Radhi

[Rob_D]

Hi Radhi,

The different Access Levels work as follows -

Read
The user can view the items (e.g. cells/cubes) but not write or edit the data in them.

No Data
This makes any data in these items not applicable for any calculations and the items will be hidden from the user. As a result these items will effectively be treated as being 0.

In addition the data is not downloaded for planner so using this option can help improve the peformance of your Packages.

Hidden
This is similar to the 'No Data' option above in that the items cannot be seen by a user but the key difference is that the data can still apply to calculations and data will be downloaded for the planner, so performance is affected.

Examples
P&L lines that are deemed invalid for certain Cost Centres can be set as 'No Data' to prevent the user putting data in them and ensuring they are treated as 0. 

'Hidden' can be used to hide any calculation lines that we need but don't want users to see.

Hope this helps.

Kind Regards,
Rob

[raabjerg]

Be aware that if there are any existing data along the dimensions of a 'no data' access table, these will be deleted and will not reappear if you remove the 'no data' access table.

Kindly,
raabj

[Radhika]

Thanks a lot...


Radhi