Forum Discussion

MarcR's avatar
MarcR
VIP
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
ChristianW's avatar
ChristianW
Valued Contributor

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:

 

RafMarques's avatar
RafMarques
New Contributor III
2 years ago

Hi ChristianW,

This works perfect!

Is there any change to join the names with descriptions? 

Example: Acc1 - Expenses

 

Thanks

Raf

  • ChristianW's avatar
    ChristianW
    Valued Contributor
    2 years ago

    Hi Raf

    Yes, you can loop the rows in the business rule and add the descriptions for the needed dimension members.

    Cheers

    • RafMarques's avatar
      RafMarques
      New Contributor III
      2 years ago

      You're right Chris.

      I can loop and either add another dataTable field or concatenate after getting the description.

      Was wondering if there was an "option" to turn descriptions on/off 🙂 - maybe an enhancement.

       

      Thanks

      Raf