Best Of
-
Re: Is there a good way to add/subtract quarters from the current date?
Hi Dan, I would play around with Positional Calculations: and Dimensional Expressions: Maybe in combination with Custom Attributes. Also, from what I have seen, in Dimensional Expressions you may als…1 -
Re: Is there a good way to add/subtract quarters from the current date?
Dan, Hopefully, you created your expression as a Custom Attribute associated with Time. Below, I'm sharing Custom Attributes for various levels in the Time hierarchy in case anyone finds them useful.…2 -
Re: How do you make a repository variable available in a consumer space?
Session variable is better practice. Otherwise, you'll need to include the publish of the script I stated above in the daily Orchestration. That isn't advisable.1 -
Re: Removing " and \ characters from strings
So the \\ worked and actually removed the quotes as well (maybe Birst wraps the string in double quotes if it has special characters?). Thanks!1 -
Re: LEFT OUTER JOIN with WHERE acting like INNER JOIN
Users do not have access to the physical SQL issued to the Birst DW.1 -
Re: Rules in Updating Fact Table
Enrico, I had posted documents in the community.infor.com version at https://community.infor.com/members/1714466/blogs. I haven't had time to post the equivalent in this community. I appreciate that …1 -
Re: Rules in Updating Fact Table
You need the columns that are grained, the delete flag AND the columns used for Incremental Refresh Delete Key as output for the Scripted Source altering the measure and adding the flag. Birst engine…1 -
Re: How can I check if something is not a number
Dan, The result is correct in your example of IsNan('test'). False = numeric; True = not numeric as stated in the on-line doc: "Evaluates an expression and returns TRUE if it is not a number and…1 -
Re: How to send Event Messages to Outlook
We're not yet working with ION events, thanks. Our Network Admin figured out on his end how to relay Infor messages using our smtp server. We simply modified the Intranets form. Thanks.1 -
Re: Is possible to have a unique file name while implementing a ION integration.
Noting that if you use a custom header, you do need to define it in the catalog so that in the File Name builder you will have that choice when you request the prompt for what is available. You may b…2