Forum Discussion

gsfeliu's avatar
gsfeliu
Contributor II
3 months ago

CellStatus retrieves a different status than shown in the Cube View

Hi all, I'm trying to build a CV with Entities on rows and Scenarios on columns that will show the status of the cell with the help of a Dynamic Calc. Here's the aspect of the CV (Scenario and UD...
Metadata
Security
  • T_Kress's avatar
    T_Kress
    3 months ago

    I wonder if you dimed the cell status as a True or False Boolean like this:

    Dim isReadonly = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"Your YourCube","YourCellPOV").DataCellEx.DataCell.CellStatus.ReadOnly

If Not isReadonly Then
Whatever you want to do
End If

    If it would behave differently?

    I am doing something similar and it is working for us.

T_Kress's avatar
T_Kress
Contributor III

I wonder if you dimed the cell status as a True or False Boolean like this:

Dim isReadonly = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"Your YourCube","YourCellPOV").DataCellEx.DataCell.CellStatus.ReadOnly

If Not isReadonly Then
Whatever you want to do
End If

If it would behave differently?

I am doing something similar and it is working for us.

gsfeliu's avatar
gsfeliu
Contributor II
3 months ago

Thanks Teresa. It worked!

Interestingly, the approach I was following is basically the same. However, the Api syntax for CellStatus returns a different string from the BRApi one that you proposed (and that I'm now using).

For the record, here's a comparison:

Dim sApi = Api.Data.GetDataCellEx(sScript).DataCell.CellStatus.ToString
Dim sBRApi = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"CORP",sScript).DataCellEx.DataCell.CellStatus.ToString

'*** RESULTS ***
'  Api = StoredBits: 0, DerivedBits: 264,    ExistenceType=NoData, StorageType=NotStored, NoDataZeroViewOverride: Default, Invalid: False, Error: False, IsDefaultFreq: False, ReadOnly: True,  ReadAccess: False, WriteAccess: False, CanCalculateFromGrids: False, IsLocked: False, IsFromCalcScript: True,  IsDynamicCalc: False, IsCalcStatus: False
'BRApi = StoredBits: 0, DerivedBits: 262196, ExistenceType=NoData, StorageType=NotStored, NoDataZeroViewOverride: Default, Invalid: False, Error: False, IsDefaultFreq: True,  ReadOnly: False, ReadAccess: True,  WriteAccess: True,  CanCalculateFromGrids: False, IsLocked: False, IsFromCalcScript: False, IsDynamicCalc: False, IsCalcStatus: False

Also, note the difference in DerivedBits. I wonder what the Api is looking at.

Kind regards,

GSF

 

 

  • T_Kress's avatar
    T_Kress
    Contributor III
    3 months ago

    Strange, but glad it worked!