Eliminate Holidays in Birst Report

Searched for how to eliminate Holidays and didn't find anything.

Looking for a way to eliminate holidays, we calculate base on the number of working days in the month also holidays (Non ship days)

This give us the # of working days in the month just not holidays if they fall in the week.

STAT(sum,0,[Time.Month Seq Number],SELECT 1,[Time.Month Seq Number],[Time.Date] FROM [ALL] WHERE [Time.Month Seq Number]=%0 AND [Time.Day]<>'Saturday' AND [Time.Day]<>'Sunday')

Find more posts tagged with

Comments

Legacy Contributor

One way could be to add a Holiday flag as a Custom Attribute if you know the dates. Then you could also add in the [Time.Holiday] <> 'Y' I believe.

Dan Rosen

If you create a dimension with your company holidays, let's say a hierarchy Holiday with a field called Holiday Date, you could use a condition such as: [Time.Date] not in (select [Holiday.Holiday Date] from [all])

0712131256598360.doc

Diane McElhiney

@drosen suggestion is the preferred design as you'll want to capture multiple historical years of holiday. Having a custom attribute with multiple IF statements increases maintainability. A yearly scheduled Orchestration reading a file is a sustainable, easy maintainable method.

Legacy Contributor

Diane--

Does adding a new hierarchy to the pre-built content require the purchase of Enterprise? I am still getting my arms around what is and is not allowed with Infor Analytics vs Birst Enterprise. I believe hierarchies can be extended but I am unsure if they can be added unless you purchase enterprise. Of course the way this is working the point may be moot.

Diane McElhiney

@billpayne

Bill, yes, an Enterprise license is necessary, to achieve a change, such as described in this post (though I believe this post is general Birst architecture) to change any aspect of an Accelerator (or starter kit, the preferred terms for our ERP Birst Analytics content) Analytics Content. Without the extended licensing, the only connection is the Infor Data Lake and only creation/editing of visualizations is allowed.

Copyright © 2025 Infor. All rights reserved.