Forum Discussion

WernerN's avatar
WernerN
Contributor
3 months ago

Spreadsheet rule in Workspace Assembly - Dont seem to be able to add it in Spreadsheet

Dear Community Members,
I have a spreadsheet rule in my own workspace assembly.
The workspace is set to 'shareable'.

But the BR does not show up when i try to add in Table View Definition

When i define a rule outside of my Workspace in the regular Business Rule section my spreadsheet rule shows up.

Did I miss a setting somewhere to tell Spreadsheet to look into Workspaces?

Thanks in advance

 

 

 



 

  • Ioana's avatar
    Ioana
    New Contributor III

    Hi,

    I think the object lookup BR list only shows the BR from the 'Application' type Business Rules.

    Can you try adding the BR without using the object lookup?

    This should be the syntax: Workspace.WorkspaceName.AssemblyName.FileName

    Thanks,

    Ioana

    • WernerN's avatar
      WernerN
      Contributor

      Thank you for your response Ioana,
      Did not work thought.  I tried in the Spreedsheet function in OneStream and in Excel.
      Tried BR name with and without .vb suffix.  OneStream accepts input, no error, but alas also no tableview.

       

      • Ioana's avatar
        Ioana
        New Contributor III

        Try replacing 'Current' with the actual workspace name. No .vb suffix is needed. In the OS documentation, this is the syntax: