Forum Discussion
Solved
Cell Details Export via Business Rule
Hello Experts,
I am trying to export Cell Details to a CSV using a business rule function as shown below:
If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("Export_CellDetails_...
The E# (and the S#) is only needed, if it says filter in the parameter name, I like to correct my previous statement. In the help it says:
Dim sValue As String = BRApi.Finance.Data.ExportCellDetailToCsv(si, serverFilePath, entityDimensionName, entityMemberFilter, scenarioName, timeMemberFilter)
This means, your code should be like this:
Dim sValue As String = BRApi.Finance.Data.ExportCellDetailToCsv(si, csvFilePath, "
E#T_Entities", "E#EB1000", "S#ACTUAL", "T#2022M3")=
Dim sValue As String = BRApi.Finance.Data.ExportCellDetailToCsv(si, csvFilePath, "T_Entities", "E#EB1000", "ACTUAL", "T#2022M3")
Is it working?
Hi Christian,
Cell_Details.csv was closed when I was getting the error. Based on your reply I closed all other excel instances and restarted my machine to make sure there is no hung instance but still same error. As you can see below there are only 2 programs opened.
ChristianW
OneStream Employee
OneStream EmployeeIt is a network drive, is it possible, that other processes are blocking the file? Like a virus checker or a backup tool?
I don't think it is necessary a Onestream server problem, because I can't replicate the problems, but I work locally.
Some things you might like to test:
- Can you delete the file manually using the file manager? Is it then working?
- Can you remove the delete section from your script (i don't think it is needed).
- If you add a timestamp to the file name, you will always create a new file. Is it still creating this problem?
I hope some of this helps.
Hi Christian,
There might be some process blocking my export and causing error. I will ask the admin to check this. I will also add a time stamp to see if the problem goes away.
Thanks for the suggestions.