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
ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
4 years ago
MarcR wrote:

In the binary table itself i see as contents of the CellAmounts the following:

When i convert this to a string i see a binary code that i cannot read.

Does anybody know how to write the select statement in SQL to see the Value fields in the CellAmounts column so i can filter on them?

Just a thought (I still don't think it is a good solution): Did you try to convert it to a decimal(28,9)?