About Bhavesh

Hi,   I have a P&L with 20 line items currently in a module. This has 2 other dimensions Entity & Division which are Lists. It has native versions as well and monthly time. I'm trying to create a new module which takes some lines from this P&L with different combinations of Entity & Division which I'm comfortable creating using Select statements.   However the issue I'm faced with is I need to create a report which has versions and variances such as Actual, Forecast, Var, Prior Month, Prior Month Var, Last Year, etc.   I have created a separate module for versions and tried using this as a Line Item Subset (LIS) but for some reason cannot get data down to the P&L line item, all I get is the same number across all P&L line items. Any help is appreciated.   ... View more

It would be great if we could schedule Imports & Processes during Month End dynamically. e.g. Each Month I need to edit my schedule to update the Start Date & End Date for the relevant month end period. Would be great to have 1st day of month as a selection from Start Date and 7th day of month for End Date as an example so that I don't have to edit can change my schedule each month for Hourly updates.     ... View more