The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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:
My Result (partial screenshot only as from Client App):
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!
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)
11 Replies
It should be in the Validation -> Rule Text tab show as below -
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?
You should look at the Rule Text column(highlighted in Green) and not the heading. You can display any text.
Apologies - I see you have a column 'Rule Text'. I don't have that. Is there a setting somewhere to include/show it?
Thanks!
It could be hidden between the columns. Can you share a screenshot of all the column headings without any data.
I have tested on both 6.8 and 7.4.1 and Rule text gets displayed on both.
I've just tested in 7.3.1 and it's fine - I'm thinking it's a 7.2.2 bug. Thanks for your help 🙂
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
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)
Absolutely ! How can i forget this 😞
