Using special national characters in unittests with NBI

First of all, if you have a .csv file containing the results that you want to compare with your test and the result contains special national characters, then you need to encode the file in Unicode before saving the file. You change the encoding in Notepad for Windows as shown below.

SaveUnicode

If your .mdx file with the test to perform contains national characters in Danish that could be the characters æ (ae), ø (oe) and å (aa). Then you have to translate them to these characters to make them work.

æ æ
Æ Ã†
ø ø
Ø Ã˜
å Ã¥
Å Ã…

More characters can be found here.

An example of and MDX-query with national characters for in .mdx file for unittesting in NBI would look like the query below.

-- MEASURES IN A CUBE – SPECIFY CUBE_NAME BELOW
SELECT CUBE_NAME AS [CUBE],[MEASUREGROUP_NAME] AS [FOLDER],
[MEASURE_UNIQUE_NAME] as UNIQUIE_NAME, [MEASURE_CAPTION] AS [MEASURE],
[MEASURE_IS_VISIBLE]
FROM $SYSTEM.MDSCHEMA_MEASURES
WHERE CUBE_NAME ='MÆJ' (that is MÆJ)
ORDER BY [MEASUREGROUP_NAME]