Access data from excel through business rules
Hai everyone,
I am trying to access the data from excel through business rule and use it in the business rule.If anyone know the VB.net code,please share with me.
Forum Discussion
I'm not sure I follow.
- if you want to produce arbitrary data through a BR in OneStream, for people to use in Excel, use TableViews. They will allow anyone with the OneStream Excel add-in to retrieve your custom tables of data.
- if you just want to retrieve OneStream Cube data from an Excel sheet, use the functions made available by the add-in. No need to code anything.
I agree! Not sure I understand the request.
If you go down the route of using openXML, I would suggest to re-think the requirements and investigate the exact use case. There may be much simpler ways to solve this simply by adjusting the process, thereby also improving the user experience as well as audit trail.