Rules
Discuss Formulas and Business rules for your application
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

[howto] Use "Insert Code" when posting on Forum boards

Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample" button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code...

tmp.png 1c_code.gif

Resolved! Time Parsing Rule

I am trying to write a parser business rule to pull out the middle portion of a date string from a data source. The file has the date as "1-Jan-23" and I want to pull out the Jan. On the data source, I have the time dimension assigned to the proper c...

bennovak by New Contributor II
  • 1810 Views
  • 4 replies
  • 0 kudos

Resolved! How to get the Name of a Cube View in Cube View Extender Rule?

Based on the XML, it looks like I need a reference to the OneStream.Shared.Wcf.CubeViewItem object that contains the CubeView. The CubeView object doesn't seem to have a property for it's Name.Does anyone know how to get the name of the Cube View cur...

RobbSalzmann_0-1682970503044.png RobbSalzmann_1-1682970519828.png

Resolved! Loading CSV containing special characters to an application table

Hi all, I have a dashboard with an SQL table editor component. Through the component in the dashboard, I can save text to the table, including special characters. For example, there is no problem in saving a string containing α (alpha). Now I am tryi...

AndreaF_0-1681984992114.png AndreaF_1-1681984992115.png
AndreaF by Contributor III
  • 1369 Views
  • 3 replies
  • 0 kudos

Bulk updating transformation rule

1. I am trying to export as trx for the derivative rule with a business rule in it. 1a. Once it exports, the exported file doesnt have the business rule name in it. (OR)2. Exported the rule as xml via application export and then opened it in the exce...

OS_Pizza_0-1680767340656.png OS_Pizza_1-1680767459345.png OS_Pizza_0-1680770214363.png OS_Pizza_1-1680770242078.png
OS_Pizza by Contributor III
  • 1264 Views
  • 3 replies
  • 1 kudos

Resolved! matrix parser rule to change date to long

Hi, I have a matrix data source matrixed on Account. Sample below. One of the Account fields is a Date that I need to convert to a Long to store. I can do the conversion but not sure how to target the value to convert when in a matrixed data source. ...