I have this query (in Excel) on a Hyperion Database. One of the lines reads like this:
<Link ((<LEV("Customers", "Lev0,Customers")) AND ( <IDESC("FRANCE")))
In this case FRANCE is a variable for a country. There are some 20 countries in all.
I get the name of the variable from another sheet and want to create a text string where the parts to the left and right contains quotes as part of the text.
"<Link ((<LEV("Customers", "Lev0,Customers")) AND ( <IDESC(""&A1&"")))" does not work because of the additional quotes. Any ideas