Forum Discussion

SRAI's avatar
SRAI
New Contributor III
3 years ago

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_...
Finance
  • ChristianW's avatar
    ChristianW
    3 years ago

    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?

SRAI's avatar
SRAI
New Contributor III

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's avatar
ChristianW
Valued Contributor
3 years ago

It 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.

  • SRAI's avatar
    SRAI
    New Contributor III
    3 years ago

    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.