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...
Forum Discussion
If all suppression is off, that pretty much leaves POV in the QV matches POV in the calc or possibly member settings.
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)