Hello. Just joined and looking forward to collaborating. Any good recommendations for BQL reference materials? Thank you.
Please start with the on-line help searching for BQL. Overall, there are sessions on Infor Campus (a few are free, others your company needed to have purchase education points). If you are new to Birst, it is advisable you take the 4 training sessions which provides foundational knowledge of the product especially in the area of modeling and ETL.
https://support.infor.com/espublic/EN/AnswerLinkDotNet/SoHo/Solutions/SoHoViewSolution.aspx?SolutionID=2170885&kb_accessed_from=KBViews This KB will provide pdfs of Birst documentation if you prefer this option.
Hi Diane. I'm sorry I'm still figuring out how to get around in Community. Thank you so much for taking the time to advise. I've done all the Foundations training and some of the advanced self-directed training. This certainly has helped but was hoping to find some deeper examples on scripts, such as nested IIFs. I keep plugging away and eventually usually crack the code. LOL Thanks again and apologize for delay in getting back to you. Mitch
Hi Christina. Sorry I missed this response. I really appreciate you pointing me in the right directions. I have taken several courses so that is helping. I was a little disappointed that the section on IIF was like a paragraph and hoped might delve deeper especially in nesting. I was not having a lot of luck in using IIF and incorporating with filtering, such as I would with a SQL statement or in Excel. I think it's likely a syntax issue. Mitch
Do you have an example of the filter syntax you are trying to use and what you are trying to accomplish?
Mitch,
No worries. We want you to be successful in everything Birst by providing a direction. I'll also suggest you can contact your Customer Success Manager and they, in turn, can put you in touch with a Technical Success Manager to review concepts for which you want a deeper understanding and use.
Hi Dan. I got a little trigger happy posting. This is a snip of the report I'm trying to emulate that I do in Excel. It's basically by Plant and by Month, on a pivot. The challenge is that I have to use a filter for account and cost center ranges on these "Dims", but in my Excel version I don't use just one set of filters. Hope that makes some sense.
