Skip to main content
GParreiras
Contributor
Aug 7, 2024 7:38 PM UTC
Solved

FilterMembers using Cb#Cube

Hi All, 

Is there a way to the use cb#cube in the data buffer FilterMembers? 

I'm trying the following, but it does not work. 

 

Dim sourceBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("RemoveZeros(FilterMembers(Cb#Cube:V#Periodic, [A#123.Base], [U7#Top.Base]))",)

 

Thanks.

HenningAnswer
Employee - Advisor
Aug 8, 2024 6:21 AM UTC

Hi, yes, that should work. Try including the data unit dimensions such as this:

Dim sourceBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("RemoveZeros(FilterMembers(Cb#myCube:E#myEntity:C#Local:S#myScenario:T#2021M1, [A#Top.Base]))")

When I run this formula from a different cube and different scenario etc. this logs the correct data to the error log when I log the content.

 

(You can log the data buffer content to the error log like this:)

sourceBuffer.LogDataBuffer(api, "My data buffer content (see details below)", 100)

 

View in thread

4 replies

Employee - Advisor
HenningEmployee - AdvisorAnswer
Employee - Advisor
Aug 8, 2024 6:21 AM UTC

Hi, yes, that should work. Try including the data unit dimensions such as this:

Dim sourceBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("RemoveZeros(FilterMembers(Cb#myCube:E#myEntity:C#Local:S#myScenario:T#2021M1, [A#Top.Base]))")

When I run this formula from a different cube and different scenario etc. this logs the correct data to the error log when I log the content.

 

(You can log the data buffer content to the error log like this:)

sourceBuffer.LogDataBuffer(api, "My data buffer content (see details below)", 100)

 

    GParreirasAuthor
    Contributor
    Aug 8, 2024 12:21 PM UTC

    Hi Henning, Thanks!

    In the end, I was able to filter the data buffer using the cube, but I had to remove the account filter to make it work.

    Here is the scenario: Cube1 has the Acc1 dimension, and Cube2 has the Acc2 dimension. When initiating the DM job from Cube2 and filtering the data buffer with FilterMembers(Cb#Cube1, [A#Acc1.Base], [U7#Top.Base]), it did not work. However, when I removed the account filter, it worked.

    That I'm still confused about and trying to understand why.

     

     

      Employee - Guide
      TheJonGEmployee - Guide
      Employee - Guide
      Aug 8, 2024 2:13 PM UTC

      Hi - the situation you described is actually expected behavior - let me explain why:

      When you run the DM Step with Cube2 specified in the Data Unit - the Finance Engine will cache (bring into memory) the dimensions which are relevant to that Cube which would be Acc2. When you retrieve a Data Buffer from a Data Unit outside of the one specified in the DM step and a different dimension is assigned (Acc1), the filter will not work because the Finance Engine does not have those dimensions cached. The only way to apply the filter in this case would be to remove the account filter and loop through the Data Buffer and add only the relevant account IDs to a new Data Buffer. 

      Again, this is expected behavior based on my experience but could be enhanced in the future.

        GParreirasAuthor
        Contributor
        Aug 8, 2024 2:16 PM UTC

        Hi TheJonG,

        Awesome, than you!

        Terms & ConditionsAccessibility statement