Forum Discussion

Mikki's avatar
Mikki
New Contributor III
2 years ago

Create Custom Table in Cloud

Hi,

Can we create a database table in OneStream Cloud that we can customize with our own data/columns and run report of? Any document that I can refer to?

Thanks in advance,

Mikki

 

 

  • Hey Mikki,

    Yep you can and its very useful but its done via a Marketplace app called Table Data Manager which provides the interface for the management of the tables. Check it out in OnePlace

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor

    Hey Mikki,

    Yep you can and its very useful but its done via a Marketplace app called Table Data Manager which provides the interface for the management of the tables. Check it out in OnePlace

    • Mikki's avatar
      Mikki
      New Contributor III

      Thank you. 

      The documentation is helpful but not much on whether we can automate data updates. Is it possible to drop/load data using Business Rules or DM step or any other method?

      • DanielWillis's avatar
        DanielWillis
        Valued Contributor

        Yes definitely. You can insert, update and select from these tables using business rules etc. They get created with an XFC prefix in the application database.

  • Henning's avatar
    Henning
    Valued Contributor II

    Hi, I agree with Daniel, Table Data Manager is definitely the first way to go! Simple to operate. I just want to add that one might also create custom tables with Business Rules in case someone may need to be more flexible than what is possible in TDM. Custom tables are utilized in many OneStream solutions to leverage the full capability of the platform and address reporting needs appropriately. As you know not all data should be kept in the cube, which is exactly why you are looking for a custom table.

    You may also check out material in the Academy and the trainings OneStream offers, especially on the BI  and Planning (XP&A) side of things.

  • arpitm's avatar
    arpitm
    New Contributor III

    Hi,

     

    Can you also modify the tables for other marketplace solutions ? For example I am trying to insert a few rows in one the tables for Application Contol Manager via Business Rule. There are no errors reported while executing the business rule but my table is not being updated.

     

     

    • Henning's avatar
      Henning
      Valued Contributor II

      Hi, I can only advise against that. Anything like that will render the marketplace solution in use unsupported and might even break it.