Forum Discussion

vijay's avatar
vijay
New Contributor III
2 years ago

Saved cell data not retrieving in Quickview

hi, Cell data for the below intersection has been saved into the cube.  Error logs  shows the percentage value getting saved into the intersection. But its not showing up while reteieivng with the Q...
Finance
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

If all suppression is off, that pretty much leaves POV in the QV matches POV in the calc or possibly member settings.

 

  • vijay's avatar
    vijay
    New Contributor III
    2 years ago

    hi,

     

    After using the below statements the % did got saved into the UD8 member , but it got rounded off. I want to get the decimal stored into the UD8 atleast 6 digits after the period. Is there some setting that i can use to acheive this. When i print in error log , it looks okay but in cube member its getting rounded off. 

     

    Dim LRPpercentangeString As String = "CB#CL_AOP:A#"& AccountBase.Name &":F#None:O#Forms:I#None:U1#"& UD1Base.Name &":U2#None:U3#" & ChannelBase.Name & ":U4#Base:U5#"& StatusBase.Name &":U6#None:U7#None:U8#LRP_Percentage"
    Dim LRPpercentangeStringValue As Decimal=   (baseAmount.CellAmount/TriberParent.CellAmount) * 100
    api.Data.ClearCalculatedData(LRPpercentangeString,True,True,True)
    api.Data.Calculate($"{LRPpercentangeString}= " + LRPpercentangeStringValue.ToString("N6"))
    brapi.ErrorLog.LogMessage(si,$"{LRPpercentangeString}= " +LRPpercentangeStringValue.ToString)