02-07-2023 05:16 PM
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
Solved! Go to Solution.
02-07-2023 05:19 PM - edited 02-07-2023 05:19 PM
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
02-07-2023 05:19 PM - edited 02-07-2023 05:19 PM
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
02-07-2023 09:54 PM
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?
02-07-2023 10:24 PM
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.
02-08-2023 03:34 AM
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.
05-31-2023 09:17 AM
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.
05-31-2023 09:30 AM
Hi, I can only advise against that. Anything like that will render the marketplace solution in use unsupported and might even break it.
05-31-2023 09:32 AM
Thank you for the response