Forum Discussion

sdayringer's avatar
sdayringer
New Contributor III
2 years ago

Intercompany Entity Description

I don't know much about method queries, so I'm hoping to get some feedback on how to build off of or reference the data tables as well as where these tables are stored. The ICMatchingForWorkflowUnitM...
Finance
  • JackLacava's avatar
    JackLacava
    2 years ago

    When in doubt, for an adapter, you can clear the Method Query property and launch it with the Test Data Adapter button. The resulting error message will contain some documentation on the parameters the method supports. In your case, I get this:

    Unfortunately, it doesn't look like any of those parameters concerns the manipulation of output format, so we'll have to do a bit more work.

    Let's assume our Entity looks like this:

    On the Report Designer, we create a Calculated Field by right-clicking on the datasource element in Field List:

    Then we right-click on it, and Edit Expression:

    In the expression, we take values from the PrimaryEntity field, and strip anything before the separator:

    Substring([PrimaryEntity], CharIndex(' -', [PrimaryEntity])+2)

    Then we drag and drop the calculated field onto our detail band, to create a label bound to the field. In this case, I've placed both the original field and the new one side by side, to show original value and new ones. The circle in the middle is just a marker, you don't need it.

    Let's look at the results using the Preview tab top-right...

    Woot!

    For more detailed info on the Report Designer, you should grab the Studio guides, which were last shipped in OneStream 7.0.1 - available in the Platform area of Marketplace, just change the version to 7.0 and grab the On-Premise Server and Documentation package, it will contain the PDF guides.

     

     

JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

When in doubt, for an adapter, you can clear the Method Query property and launch it with the Test Data Adapter button. The resulting error message will contain some documentation on the parameters the method supports. In your case, I get this:

Unfortunately, it doesn't look like any of those parameters concerns the manipulation of output format, so we'll have to do a bit more work.

Let's assume our Entity looks like this:

On the Report Designer, we create a Calculated Field by right-clicking on the datasource element in Field List:

Then we right-click on it, and Edit Expression:

In the expression, we take values from the PrimaryEntity field, and strip anything before the separator:

Substring([PrimaryEntity], CharIndex(' -', [PrimaryEntity])+2)

Then we drag and drop the calculated field onto our detail band, to create a label bound to the field. In this case, I've placed both the original field and the new one side by side, to show original value and new ones. The circle in the middle is just a marker, you don't need it.

Let's look at the results using the Preview tab top-right...

Woot!

For more detailed info on the Report Designer, you should grab the Studio guides, which were last shipped in OneStream 7.0.1 - available in the Platform area of Marketplace, just change the version to 7.0 and grab the On-Premise Server and Documentation package, it will contain the PDF guides.