-
Change Source of a Model from Data Hub Dev to Data Hub Prod
Hi All, I am working in a User Story of a Dev Model to change the sources of data from Data Hub Dev to Data Hub Prod. The model In Dev I am working by now has already around 70 actions that are pointing different views of Data Hub Dev as a source of data. In my analysis I found that one way to do the change is: * Go to the…
-
How to declare a variable in denodo?
There is a question related to this topic but is not the same that I am going to ask, I need to do something similar as we do in SQL but this time in Denodo. This is in SQL: DECLARE @curr varchar (10); SET @curr = 'USD; SELECT Country, Currency FROM Currencies WHERE Currency = @curr; I have tried something like this in…
-
How to shorten names for a data flat file you use t import into List
Hi, I have a List that will get populated once a month from a flat file that is given to me from IT. The only issue is that some of the naming in the flat file is too long to bring in as a List. And if the name is too long then Anaplan will not bring in that name into the list. I want to know what is the best way to fix…
-
Export data using Cloudworks
Hi, Is there a way i can use CloudWorks to export data without using the connector? I cannot select the Target folder where i want to save the extracted file. Thanks in advance for helping. Regards, Tom
-
How to remove List Subset Item from Labels in Export
Hi I have an export from module, where one of two dimensions is the List Subset Item. When I want to export it as Tabular Mutliple Columns - I see in the Lables only name (connected to the First Dimension). I need to removed List Subset Item from my export, like other labels. I wonder how to do it?
-
Chunks Error
chunksArray = jsonResponse["chunks"] KeyError: 'chunks' Hi all, I have connected with Anaplan through API with help of Python . Basically I am Exporting file from Anaplan for getting suggestion But now If i am using my credentials and my Model it is working fine. But for others it showing error above pasted. Chunks are…
-
is there a way to forecast expenses by vendors?
I'm trying to forecast the details by department's with their vendors, like for example Anaplan as a license vendor I want to forecast by that line of expense as part of the Technology department that eventually will roll up to the Software expense P&L as part of the total company. Not sure if I need a list for Vendors and…
-
How to check if authentication works after CA installed on Anaplan
Hi, What is the best way to check if authentication works properly after CA is installed on Anaplan? I followed https://help.anaplan.com/1493b16d-7294-47d6-bd8d-056962e9b8da-Use-CA-certificate-authentication to try to check the CA, but it returns "Failure_bad_credential" I'm not a Postman expert nor integration expert so…
-
Integration acknowledgement to Anaplan
Hi, In the scope of an integration from Anaplan to a target system using Mulesoft, I want the best and most efffective way to perform "Ready" and "Success" flags. I explain : Mulesoft flow will use a scheduler to connect to the Anaplan connector at a regular timing. If the Anaplan user performed a new calculation and have…
-
Data Copy for more than 10k rows of a single line item.
Hi Community, What are the possible ways to load a single date into (Date Formatted) line item which has more than 10000 records. I know the few drills which is 1) Importing manually by creating a csv of that single line item with multiple rows 2) Copy down method (applicable only for 10k rows only) Does anyone have any…
-
Can you take a Copy of a model at a point in time without having to restore it?
Hey team, I want to take a copy of a model at a point in time and see the data in it without restoring the current version model to that point. Is this possible and if so how do I do it? Regards Padraig
-
Export Top Level item using Tabular Multiple Column
Dear Anaplan Community, I would like to export data using Tabular Multiple Column (to use it later as export action in Power BI with Anaplan Connector), including the top level item of my list. In the export definition, I did NOT select "Omit Summary Items", however, in my export I don't see the Total row. What am I doing…
-
AM365 and Google Sheets Add-in SSO login redirecting to Anaplan Home
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue If you have a live session on Anaplan on another tab, when attempting to authenticate via SSO, you will be navigated to Anaplan Home on the popup window instead of it redirecting and…
-
Importing into a Numbered List from a saved view
Hi All - I feel like I am missing something simple here. I have a saved view from my data hub model that I am using to import into a spoke model. I am setting up a numbered listed in the spoke model b/c of duplicate data. I have set up a display name and have successfully imported the data from the saved view. What I do…
-
Export Action to Power BI
Hello! I´ve created an export button to export a table from Anaplan to Power BI using Anaplan Connector. I can see the table in a list of export action in Anaplan, as shown below: However, I´m not able to find this export in Anaplan Conector in my Power BI. I search the right way to get to the table but this export name…
-
Upload same Idlaoder with differents amounts
Hi everyone, Can you help me with the next problem, please? I need to load some information and the criteria for upload is the Idloader list. I am testing what happens when uploading two rows that have the same Idloader but different amounts and I am waiting that Anaplan to upload just the last amount. In this case, if I…
-
extend time to access anaplan
Hi, Unfortunately, my access to my profile was expired, All my models and apps and Data have disappeared which I need to finish my course. I am middle of level 2 and it is very important to finish my lessons. Do you Know How can I recover my DATA or extend my access? I am a student and 90 days were not enough for my to…
-
Importing Hiearchies
Hi, I'm trying to import our company structure, the structure is made up of Department > Division > Cost Centre > Budget Some items in the Division list have the same name as their parent and are being rejected e.g. Marketing > Marketing > Brand > Brand Budget Does anyone know how to resolve this? Thanks
-
Import takes time with filter view
Hi, I want to know filter function. I run Import Action from saved view which filtered by Lineitem. But It takes long time. The point was module pivot. View A and B was filtered by same Lineitem. But it takes shorter set source module as ViewB than ViewA. View A ProductLocationTimeAmountAX1/11AX1/22AX・・・3BX1/14BX1/25BX・・・6…
-
Anaplan Connect with Snowflake & Public/Private Key
I am attempting to utilize Anaplan Connect to move data from Snowflake into Anaplan. In order to work with our snowflake setup, I need to use a public/private key pairing as opposed to a snowflake username/password. I have been told the most recent version of connect (3.0.0) does not work without these fields and that an…