Hi,
I'm importing OPEX data from a datahub to a spoke model with the same dimensions but are getting 4x the values for every cell in the target module. Does anyone know why this might be?
Best regards,
Johan
Hi @johan.marketoft
It could be because of a missing dimension (you mentioned that both the source and target module have the same dimensions) or it can be that one of the dimensions has a different level of granularity: for instance, perhaps time dimension (if applies) is in weekly buckets in the source and monthly buckets in the target?
Check the summary methods of the Line Items in the source module, too: set them to "none" and check the result of the data import.
This is what I can think of for now. Please, feel free to share some more details or a couple of screenshots and we will be able to find the root of the issue.
Cheers,
Alex.
When this has happened to me before, it's because I'm misaligned on the time dimension. For example, imported against year, but importing into month. From the 4x comment you made, I believe it would be a quarter vs. year mismatch.
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
