LOOKUP dimensions

I have two modules : SYS REF Public Holidays & SYS DAT01 Public Holidays (Dimension: Time (Year) and Country)

I need to display a boolean of delete from SYS Data to SYS REF

I created a SYS LOOKUP

and I displayed a formula : 'DAT01'.Delete ?[LOOKUP: 'SYS LOOKUP'.ALL pays, SELECT: TIME.All Periods]

my look up works only if I select one of the countries, but not for all !

Any suggestions please ?

Accepted answers

You can write a condition after your formula, and your final formula looks like this:

'DAT01'.Delete ?[LOOKUP: 'SYS LOOKUP'.ALL pays, SELECT: TIME.All Periods] OR ISBLANK( 'SYS LOOKUP'.ALL pays)

The OR condition will return true for all items if your All pays line item from SYS14 module is blank.

Actually, it didn't work with this formula but I found a solution :

The formula in REF is : 'DAT01 JOURS FERIES'.Delete ?[SELECT: TIME.All Periods] With a set up of a summary on DAT01 : Any

Thank you

Excel plugin issue with SSO
Has anyone gotten an error like this when you have SSO and you are trying to use the Excel plug in? We have some users that get the screen below but some don't. We have checked that all users have the same version of Excel. Weird part about the screen below is it actually says the connection was successful.
ERROR 16020 |-- Anaplan API: Invalid key path
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Azure SQL Connection, database name with Hyphens in Data Orchestrator
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…