Skip to main content
M
mgreenberg
Contributor
February 22, 2022

Can you execute a Business Rule or Data Management function using the Excel Add-In?

  • February 22, 2022
  • 2 replies
  • 0 views

I want to create a button on my excel spreadsheet that will execute a BR or a DM is this possible?  I see that there are OS functions called XFGetCellUsingScript and also a XFPut but I can not find any documentation on all for any function except the basic XFGet, XFPut and GetMemberPropertyetc.   Is there documentation somewhere that I am missing?

2 replies

C
ckattookaran
Newcomer
February 23, 2022

You will have to use either Client API or REST API and create a macro to call http://server:port/OneStreamWeb/Help/Content/REST%20API/DataManagement.htm#_Toc35851156 

M
mgreenbergAuthor
Contributor
February 23, 2022

Thanks for the response but I am not super technical.  It sounds like from your answer that OS does not have standard functions or capabilities to simply call a BR or DM in the add-in.   Also still looking for documentation on the OS add-in functions

C
ckattookaran
Newcomer
February 23, 2022

There is a knowledge base article out there for the Add-in functions.

https://onestreamsoftware.service-now.com/sp/?sys_kb_id=09389b291be7601099ce86e1604bcb5d&id=kb_article_view&sysparm_rank=1&sysparm_tsqueryId=9ec76c471b6a381099ce86e1604bcb0c

I don't think there is one for calling a DM job.

M
mgreenbergAuthor
Contributor
February 23, 2022

Thanks but I followed our link and didnt see anything documents the functions.  That article just listed a couple.  This is what I am talking about (in image)

mgreenberg_0-1645625751388.png

 

Terms & ConditionsAccessibility statement