The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

MarcR's avatar
MarcR
Contributor II
4 years ago

Read/ Analyze contents of Binary columns

Hi there,  For a client i want to do a detailed analysis of the data (numbers) in the database. We want to investigate the percentage of numbers < 0.01. However, when i use the Data records i see t...
planning
MarcR's avatar
MarcR
Contributor II
4 years ago

Thanks for your reply Sai, 

The challenge is we have a weekly application profile and then the data is not stored in the DataRecord tables but in the BinaryData tables. And those have the binary column i need to read. 

I do have another solution which is not ideal but working. I run an FDX query from a business rule with a filter on the data values. That is working but it feels a bit extreme for a fairly simple query.

ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
4 years ago

I just wanted to propose a fdx query for this request. Accessing the data table directly is not a sustainable way of doing it.

  • Sai_Maganti's avatar
    Sai_Maganti
    Contributor II
    4 years ago

    Ah thanks and noted Christian. Are you able to provide some samples of FDX BR queries? I tried to find some help in the documentation and there is nothing much.

    • ChristianW's avatar
      ChristianW
      Icon for OneStream Employee rankOneStream Employee
      4 years ago

      Here is something I used for a custom IC matching report:

      'Retrieve the data for the first query
Dim subQueryDataTable As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si, cubeName, $"E#{entityName}.Base", "local", scenarioTypeId, $"S#{scenarioName}", $"T#{timeName}", "YTD", True, "Flow='None'", 4, True)

      And here is the explanation for the parameters:

       

      • nizar's avatar
        nizar
        New Contributor
        4 years ago

        Hi Christian,

         

        can you please give us an exemple with reel value ?

        i am strugle with this parametre, didn't find the correct syntaxt to get it.

        scenarioTypeId

        thanks