The XFBR function in a cubeview, will be resolved before the system retrieves the datacells, so there is no way for the rule to get the POV of a cell (because it doesn't exist yet).
The problem are dynamic queries like A#IS.descendants, when the xfbr is executed, the query isn't resolved yet.
There are several ways to work around this limitation, can you help us to understand, what you try to achieve?
Wow!! I have no idea what the differences are between XFBR vs using formula and financial business rules. Obviously, you are some big shot developer at 1S. Or are you a consultant? If yes, which company do you work for?
I was studying some XFBR code written over 5 years ago, that I inherited. I suspected there was some issue with XFBR not being able to read the cell's POV. I think what you wrote is true- which means that case, 1S consultants' use of XFBR to do conditional formatting is flawed.
I guess my first question is - why would anyone use XFBR, except to process something before retrieving datacells!!
I am asked to color a cell yellow if a user added annotation into that cell. This cell stores annotations of users who enter an explanation for why there is a variance on the row of that cell.
You just told me that I have to use a formula or a finance rule as I need the cell POV before I can retrieve the contents of the cell to see if it has text.
Koemets wrote this:
Annotations are attachments by nature, so they can't be treated as regular data cell in your code. So you need to attach them to the respective datacells> Koemets
Someone recommended the following lines of code. Do you have a better suggestion?
Dim yourText As String = api.Data.GetDataCellEx("A#variance:U8#CommentAvB").DataCellAnnotation
api.Data.SetDataAttachmentText("A#variance:U8#CommentAvB",yourText,False) ‘I don’t even know what this line does
If yourText.Equals(String.Empty) Then
' color cell pink to show that user entered text into this cell
Return "Pink"
Why are you not just showing the annotation in a column next to the data?
You solution with a pink cell is probably possible, but I need to know the dimensions in the rows and the columns. Today is a little late in Europe to start such a project, but I will try to build something this week.
I have a very simple CubeView - cells under "Reason code" column have these dimensions:
U8#CommentAvB , V#ANNOTATION
Each row is a dept - they have to explain why there is a large variance.
Please don't bother to build something for me -if you are very busy. I learned from news that Europeans value their life-after-office hours, which I totally agree with ; so please don't work overtime for me.
