We are also bloggers

Blog section

Blog section

We are also bloggers

3

Tips for using Table Views in OneStream XF 5.2

Table views can be used when creating Dashboards where relational data is required. This feature offers a flexible solution to design a form or as a data collection tool.

Tips and tricks for using Table views

  • Table views can simply be accessed via the OneStream Windows Application SpreadSheet utility.
  • This feature is designed to update records in a data table and utilizes client-side functionality. It is not possible to do inserts to create new records and does not support paging (for large data sets).
  • The table view is defined in a business rule with new BRAPI functions (also for authorization), this is then inserted into a spreadsheet component.
  • A new SpreadSheet Business Rule type is available with functions like GetCustomSubstVarsInUse, GetTableView and SaveTableView to define the look, feel and behavior of the table.
  • The “OneStream XF Table Views” guide contains explicit examples of possible functionality within the script as an easy starting point.
  • To make the table view more dynamic, diverse parameters can be used. Also, member functions like IsDirty, IsHeader, OriginalValue can be used to determine how the data is processed.
  • The table view uses XFTV named Ranges.
  • Security is included within the script and can be applied on data- or table level.

Tips and tricks for using BI Dashboard Designer & Viewer in OneStream XF 5.2

Do you know how to use BI Dashboard Designer & Viewer in the version 5.2?

If not, then keep reading our next article on this subject.

Read more articles

Press ReleaseOneStreamSonum Article
Sonum International announces Expansion into the US and Canadian Markets Through Merger of Infogility’s Financial Planning and Consolidation Business Unit

Sonum International announces Expansion into the US and Canadian Markets Through Merger of Infogility’s Financial Planning and Consolidation Business Unit

Sonum International, a OneStream Diamond Partner, has made a firm commitment to the US and Canadian markets, by combining operations in the Americas with that of Infogility.

Upgrade yourself!

Wanna see our projects portfolio?

How Sasol is reshaping finance control using models built in OneStream

How Sasol is reshaping finance control using models built in OneStream

Royal Cosun automates tax processes with tax provisioning template

Royal Cosun automates tax processes with tax provisioning template

From construction budget to regular finance at RWG with Anaplan

From construction budget to regular finance at RWG with Anaplan

On-the-fly multidimensional financial insight for eDreams ODIGEO

On-the-fly multidimensional financial insight for eDreams ODIGEO

Jumia gains financial agility and resilience for the changing African market

Jumia gains financial agility and resilience for the changing African market

Flexibly responding to market change at bol.com

Flexibly responding to market change at bol.com

Tranquility during the reporting process at First Wind with Vena

Tranquility during the reporting process at First Wind with Vena

Optimizing project management at Boskalis Nederland

Optimizing project management at Boskalis Nederland

Integrated information landscape at Vivo Energy

Integrated information landscape at Vivo Energy

International growth at Paques with OneStream

International growth at Paques with OneStream

Rapid availability of reports at Flow Traders with OneStream

Rapid availability of reports at Flow Traders with OneStream

Using OneStream for results by store at Hunkemöller

Using OneStream for results by store at Hunkemöller

Streamlining Reporting at Parlevliet & Van der Plas with OneStream

Streamlining Reporting at Parlevliet & Van der Plas with OneStream

Multiple Reporting Standards at Terberg Group after Merger with OneStream

Multiple Reporting Standards at Terberg Group after Merger with OneStream

Business insights at Perfetti Van Melle with SAP BPC

Business insights at Perfetti Van Melle with SAP BPC

Retail focus at ASICS with SAP BPC

Retail focus at ASICS with SAP BPC

Q-Park Budget forecasting model with Board

Q-Park Budget forecasting model with Board

Let’s Start Something new
Say Hello!

Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit laborum. Sed ut perspiciatis unde omnis.