I want to import duplicate detail-data into Module.....
When I imported, same departmentcode data which is second same data was rejected.....
dimension（departmentcode） is Fixed and unchangeable, How can I do this?
What dimensions do you have in the Target module? Only Department? is a numbered list?
Normally, it is possible to create a numbered list with the unique combinations of Department and Department Type (Fixed or unchangeable) where Department and Department Type are properties in that list.
Hope it helps
Alex
mcdvoice wrote: I want to import duplicate detail-data into Module.....When I imported, same departmentcode data which is second same data was rejected.....dimension（departmentcode） is Fixed and unchangeable, How can I do this?
The difference between import module and from module import foo is mainly subjective. Pick the one you like best and be consistent in your use of it. Here are some points to help you decide.
import module
Pros:Less maintenance of your import statements. Don't need to add any additional imports to start using another item from the moduleCons:Typing module.foo in your code can be tedious and redundant (tedium can be minimized by using import module as mo then typing mo.foo)from module import foo
Pros:Less typing to use fooMore control over which items of a module can be accessedCons:To use a new item from the module you have to update your import statementYou lose context about foo. For example, it's less clear what ceil() does compared to math.ceil()Either method is acceptable, but don't use from module import *.
For any reasonable large set of code, if you import * you will likely be cementing it into the module, unable to be removed. This is because it is difficult to determine what items used in the code are coming from 'module', making it easy to get to the point where you think you don't use the import any more but it's extremely difficult to be sure.
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
