Create Custom Table in Cloud

[Mikki]

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

[DanielWillis · Accepted solution]

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]

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]

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]

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]

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]

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

[arpitm]

Thank you for the response