We've got a series of modules whose versions are controlled by a SYS module. We're trying to setup a nightly export so that only the most-recent forecast version exports. The problem is that if someone changes the version mid-day and doesn't change it back, we're exporting data for the incorrect version. The fix is obvious enough: create 2 cells - one that holds a copy of the Master Version Control and another the holds the most recent forecast version. Import Master Version Control to the Copy cell, then import the most recent forecast version into the Master Version control cell, export the data, then import the Copy of Master Version into the Master Version control to set it back to how it was. The problem is that what's actually copying into this cell is the cell name, not the value. See below image. Any ideas why this is happening and how I can resolve? There are no other dimensions involved and items should both be formatted as a list (as we don't use the native versions menu). I temporarily put the Copy cell to format as text to illustrate what is happening.
Hi @dspar001, you can see on the Mapping tab of the import window, the data values for your import are coming from column 1, your line item names. This is why the line item names are then populating the cell data on your import. I'm not sure how you've setup the saved view for each of the two imports in your process as you described, but you should be seeing two columns in your import screen, so you then get your Data Values from column 2, which would be your list item.
I d check how you initially setup your import action.
Make sure you are in data view and not in blueprint view when setting up the import.
I believe you are getting the line items names in your import instead of your actual content values because of that.
Thank you @david.savarin and @matthewreed for the responses. I deleted all the actions and import data sources associated with those actions, ensured that I was not in blueprint view, tried again and, unfortunately, I got the same results. I agree that the import window tab is off. I believe when one selects an option from "Data Values From:" on the right hand side of my 2nd snippet, the 2nd tab should pop up with a "Data Values To:" option, but that isn't happening
I hope it's not asking too much, but since this is a very simple setup, I'm wondering if you'd be willing to re-create this and tell me if it comes through correctly on your end.
Just to show that I'm not in blueprint view…
Hi @dspar001 perhaps create a system list with one item to dimension this model on. So you would create the dummy list, add an item ie. 'Version Selection', then choose that dummy list in the 'Applies To' section of your module. I'm sure we'll find a solution ;)
With @matthewreed 's help, I developed a solution. Things I learned and believe to be true:
Solution: After trying to piece these three things together to form what I wanted, I instead created a Boolean over-ride, using my 1st bullet-point to effect. I created three Boolean line items: Override?, TRUE and FALSE. I import TRUE and FALSE into Override? to get values I want. It works only because it's a Boolean
Thanks @matthewreed !
Now I faced below warning But I cannot find any delete action for those users I don't need anymore Can I have any action to solve this warning?
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
