Skip to main content
F
FlorisvdPoel
April 5, 2023

Retrieve Pov Account name in XFBR

  • April 5, 2023
  • 1 reply
  • 0 views

Hi everyone,

I need to retrieve the account name from a certain line in a cube view in an XFBR rule. 

So, it boils down to the need for an api.Pov.Account.MemberId XFBR equivalent.

 

Is there anyone that can help me with this issue? It seems so simple but I cannot figure it out.

Thanks!

Floris

1 reply

C
ChristianW
April 5, 2023

Can you explain a little bit more about the use case?

Is the line you need to retrieve the selected one? Are you working in a dashboard? Where do you need to execute the xfbr?

 

F
FlorisvdPoelAuthor
April 5, 2023

Hi Christian,

First of all, thanks for replying. Second, my apologies for the lack of background.

I am working on a detailed cashflow overview. The cashflow process starts with a mapping table in which we have a source account and flow, which get mapped to a cashflow account. Let's call them, source account, flow account, and target account respectively. This mapping table includes a column for flipping the sign. This is a true/false box. 

I would like to retrieve the following. From that mapping table (which is running on the data table manager), I want to return the outcome from that mapping table in the true/false box. So, if the combination of source account + source flow + target account has the flip sign condition set to true or false, I want to retrieve it in a cube view. With the business rule, I am able to retrieve the target account from a parameter (this is a bound parameter coming from another cube view). However, the source account and source flow depend on what we're looking at in the cube view. So, I cannot retrieve them with a parameter. Therefore, I would like to retrieve these values with some sort of api.Pov.Account.MemberId, which is not possible in XFBR in that way.

I hope this was more clear.

Thanks for your help!

 

C
ChristianW
April 6, 2023

There is no api.Pov.Account for xfbr, because the function is called when rendering the outline of the cubeview. You might pass a parameter to the xfbr function, but this is not working with the data of the cubeview only with headers (:name()).

In your case, I would probably use a ud8 dynamic member formula, then you have access to api.Pov.Account.MemberId.

Member formulas can also work with annotation views, so you can show + or - if you like, or a complete formula.

Dimension that only hold dynamic members don't need to be allocated to a cube, they will work in every cube.

I hope this helps and cheers

Christian

Terms & ConditionsAccessibility statement