Can you help?
Unanswered questions
-
ISFIRSTOCCURRENCE returns duplicates due to extra dimension
Hi ALL, As shown in the screenshot: Columns are Locations and D2 Roles. Each Location is mapped to a Final Region Set (e.g., Toronto).The module is dimensioned by Locations and D2 Roles. I want to export this mapping to another model, but in the target module, I don’t need the D2 Roles dimension. When I try to use…
-
Update columns in a source
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
-
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
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…