Create Excel spreadsheet from Business Rules
Does anyone know if you can create an Excel spreadsheet from Business Rules? I do not mean a csv file - I need to create multiple sheets. The OpenXMLBuilder object doesn't seem to have anything with writing files. I don't want to use a third-party object as that would require an installation or download. Thanks for any suggestions.Solved13KViews0likes27CommentsBusiness Rule debug
Hello, I'm new to Business Rule, and I'm struggling with the execution of a data management step with type "custom calculate". Currently, the execution of this script is giving me the message below : Error processing Data Management Step 'CC_FY2022_BUD'. Unable to execute Business Rule 'CopyData'. Invalid destination data unit in script 'A#Account1:C#Local:T#2022M1:S#Budget:U1#None:U3#T:U8#None:O#Import'. In the Data Management step, I have defined elements in the POV and Data Units, and "Data Units" elements seem to be taken into account correctly, but elements in the "POV" such as U2, U4, U5, U6, U7 elements that have been defined in the POV of data element task (hierarchy nodes) seem like is not considered in the calculation. So here are my questions: - What is the error message mentionned above actually saying ? - Are POC elements from the Data Element task taken into account in the Finance Business Rules ? - How do you efficiently debug a Business Rule ? Many thanks for your prompt answers 🙂 Regards,Solved8.4KViews0likes7CommentsOneStream .Net Platform Language
Was the OneStream product itself built using VB.Net? If so, I'm pretty impressed!! If it was built using C#, I'm wondering why customers are then forced to use VB.Net for business rules? It seems like a double standard. Is there a licensing reason why VB.Net is redistributed to customers while C# is not? If it isn't about licensing then maybe onestream has internal BR tooling that is incompatible with C#, or third party tooling that is incompatible? Any info would be appreciated. Obviously the selection of either .net language it is a matter of choice ... but if OneStream picked C# for development of the product, then they should allow customers to pick C# as well for our business rules.Solved7.9KViews0likes11Commentshow to debug a business rule
An allocation business rule is not allocating the rates properly . Hence we would like to debug the business rule and also figure out which intersections are passed and what is the value and allocation rate used in allocation calculation . This allocation process involves a formula in UD7 member . Please advise how to see the messages used in api.logmessage . Should we need to create a dashboard to capture the messages that are logged while running the allocations. Again, we are looking for which members used and the value / rate used to allocate.Solved7.9KViews0likes11CommentsExtract Active Entity list from OneStream by using Data Management Job
Hi all, Happy New Year! Is there a way of extracting an active entity list from OneStream including Entity Name, Description, and Currency fields by using a data management job?Any ideas will be appreciated. Thank you!Solved7.8KViews0likes15CommentsIs there anyway to download TB/Reclass files automatically using Business Rules?
I have application which has 47 entities and users who have Entity wise rights to upload TB/Reclass and Cube views. So far Admin is downloading TBmanually (using view source document) by going through Entity. Now I want to download TB and Reclass files through some business rules (if possible to be schedule to run once in Month) or some procedure for all entities using user who has administrative privilege. Thanks all in advance for your help. Regards, YashwantSolved7.5KViews0likes16CommentsSaving an export directly to the shared folder
Hi All, For a client i've created a SQL script that generates a datatable that i want to save to a .csv file. This works as expected via BRApi.Utilities.SaveFileBytesToUserTempFolder(si, si.UserName, sFileName, fileBytes) From this location i can present the file to the user from the dashboard button that is generating the export. However, this file is big and the user settings (of some users) change the number formatting of the export. Therefore i want to export the file directly to the shared folder (which is easy for the user to access from the front end: I've tried all options within brapi.FileSystem but cannot find the proper syntax to save this file directly. The 'issue' is currently solved by storing this file in the user temp folder, then copying it over to the shared folder (via another article on this forum) but that touches the file twice so preferably i want to save the file directly from the fileBytes (that is a Encoding.UTF8.GetBytes(dt) into the shared folder. Any suggestions would be great.Solved7.3KViews1like9CommentsFDX Cube View Rule
I have created a Dashboard Dara Set BR and I am attached in the data adapter. When I am trying to execute the rule am getting 0 data. See below the entity is always passing as None but when I add a log message in the code the variable is passing based on the selection and printing the correct entity. in My CV i also have the FDXentity parameter. Any Idea why it is happening ? Original Query {FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=Data,entityDimName=E#|!FDXEntity!|} Substituted Query {FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=Data,entityDimName=E#None} Thanks KrishnaSolved6.1KViews0likes14Comments