This example uses the Strategy Tutorial project, with a Microsoft SQL Server warehouse. In Strategy Tutorial, there is a table called ORDER_FACT containing the following columns:
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
The goal of this exercise is to build a report containing Order, and the difference in "business days" between Ship Date and Order Date.
If the requirement is not specifically business days, this would be a matter of creating a fact based on Ship_Date - Order_Date, creating a metric based on that fact, and reporting on that metric with Order. The fact definition would be as follows:
ApplySimple("convert(int,#0-#1)", , )
(The above syntax will be different for platforms other than Microsoft SQL Server).
However, the Business Days report is a special case because excludes holidays and weekends from the count. Since there is not any algorithm that can automatically do this, create a table in the database with this information. For example, a table called BUSINESS_DAYS:
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
This table only needs to have one column and should contain only those dates that constitute business days.
Finally, to create the 'Ship_Date - Order_Date' fact, create a view in the database that makes the calculation. For example:
Create view DAYS_TO_SHIP as
select a.order_id order_id,
count(b.business_day) days_to_ship
from ORDER_FACT a,
BUSINESS_DAYS b
where b.business_day <= a.ship_date
and b.business_day >= a.order_date
group by a.order_id
would create a view with the following structure:
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
Google Map in VIGoogle MapApple MapGoogle Map in RSDGoogle MapApple MapESRI Map in VIESRI MapApple MapESRI Map in RSDESRI MapApple Map in 10.1 (showing Grid in 10 and lower)TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user wakes up and decides to trigger a manual or custom time window data load at 5am, 1 hour before the next scheduled data load.Because this is a manual or custom time window data load, the 'Last data load start time' is not affected.6amAt 6am, the scheduled data load kicks off, not affected by the manual or custom time window data load.The 'Last data load start time' is 12am, the frequency is 6 hours, so the data load is triggered as desired.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amAn administrative user shuts down the intelligence server for maintenance.The data load schedule is not stopped.6amThe Intelligence Server is still shut down. At 6am, the scheduled data load kicks off, but fails.Because the data load kicked off, the 'Last data load start time' is set to 6am, the frequency is 6 hours, so the next data load will occur at noon. If the Intelligence Server is up and running at noon, the data load will migrate data over the entire time period since the last successful data load finish time.TimeEventDetails12amA scheduled data load occurs at 12am as desired.The 'Last data load start time' is set to 12am.5amThe data load schedule is stopped by an Administrator for system maintenance. 6amAt 6am, nothing happens.The data load schedule is still stopped.9amMaintenance finishes and the data load schedule is started again. 9am and 1 secondThe data load schedule process checks, and finds that the 'Last data load start time' plus 'frequency' is less than the current time, so the data load kicks off immediately.The data load kicks off immediately, setting the 'last data load start time' to 9am.Prompt Answer MethodRequirementsPrompts in the Target Are Answered By...Answer with the same promptSame prompt in the target and sourceThe prompt answer from the sourcePrompt userNoneThe user (prompts are displayed when the target is executed)Default answerNoneThe default prompt answer for the target promptDynamicallyAttribute element prompt in targetThe object selected in the source (for example, the attribute element that the user clicked on)Empty answerTarget prompt must not be requiredNothing (no prompt answer is provided from the source and the user is not prompted)Static element listAttribute element prompt in targetThis prompt overrides the prompt ansnwers from the source with a list of elements. Selecting this option makes the Element List area available to select the elements to be passed as answers to the element list prompt in the target.Current unitHierarchy prompt in targetSimilar to the Dynamic prompt answer method, where the prompt is answered using the object selected in the source.All valid unitsHierarchy prompt in targetAny object to the left of or above the user selection in the source is used as the prompt answer for the target. In other words, this method passes all the selections made on the source, rather than just the selection made for the link.ORDER_FACTOrder_IDOrder_DateShip_DateBUSINESS_DAYSBusiness_DayDAYS_TO_SHIPOrder_IDDays_to_ship |
Once this view is created, all that remains is to bring it into the project, include the Order_ID column in the Order attribute, and create a fact based on the Days_to_ship column.
