Skip to main content
SarahS
Member
May 12, 2023 10:25 AM UTC
Solved

Derivative Check Rule - Display CheckRuleMessage

Hi,

I'm using a Derivative Check Rule for the first time - using the sample available in GolfStream (HoustonSalesDetailOffset > ValidateCheckSum) - the Rule itself is working fine, I am getting the correct Pass/Fail Status.  My question is where can I expect to see the CheckRuleMessage displayed?

GolfStream Sample:

SarahS_0-1683886756605.png

 

My Result (partial screenshot only as from Client App):

SarahS_1-1683886888326.png

It feels like there's a column missing from the screen?  Or perhaps it should be a pop-up window on the right like with other Validation/Intersection errors?

Thanks in advance for any help!

      SarahSAnswer
      Member
      May 15, 2023 12:11 PM UTC

      In the end I raised a ticket for this - it's not a bug but a Cube Integration Setting!  We had disabled/not enabled the Label Dimension > TextValue (Text)

      SarahS_0-1684152578170.png

       

      View in thread

      11 replies

      OS_Pizza
      May 12, 2023 11:51 AM UTC

      It should be in the Validation -> Rule Text  tab show as below -

      OS_Pizza_0-1683892269310.png

       

        SarahSAuthor
        Member
        May 12, 2023 12:08 PM UTC

        Hi - mine displays the same as yours - just with the text 'Check Rule Errors' - can you get it to display something different in your example?

        OS_Pizza
        May 12, 2023 12:11 PM UTC

        You should look at the Rule Text column(highlighted in Green) and not the heading. You can display any text.

        OS_Pizza_0-1683893472638.png

         

         

        OS_Pizza
        May 12, 2023 1:49 PM UTC

        I have tested on both 6.8 and 7.4.1 and Rule text gets displayed on both. 

          OS_Pizza
          May 12, 2023 2:00 PM UTC

          Try creating a new derivative rule and use a simple expression as below.

          A#[A*]=All:V#[*]=All_View:F#[*]=All_Flow:IC#[*]=ALL_IC:E#[*]=All_Entity:UD2#[*]=ALL_UD2:UD3#[*]=All_UD3:UD4#[*]=All_UD4:UD5#[*]=All_UD5:UD6#[*]=All_UD6:UD7#[*]=All_UD7

          Read out this blog for more details on setting up the derivative rule.

          https://medium.com/@kesanmanish/blog4-onestream-the-underlooked-asset-called-derivative-8d6349c5d035

          SarahSAuthorAnswer
          Member
          May 15, 2023 12:11 PM UTC

          In the end I raised a ticket for this - it's not a bug but a Cube Integration Setting!  We had disabled/not enabled the Label Dimension > TextValue (Text)

          SarahS_0-1684152578170.png

           

            OS_Pizza
            May 16, 2023 7:01 AM UTC

            Absolutely ! How can i forget this 😞

            Terms & ConditionsAccessibility statement