Single Quote around DB rules

Post Reply
MarenC
Regular Participant
Posts: 460
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Single Quote around DB rules

Post by MarenC »

Hi,

I saw a rule where for a DB to a cube, the dimension names had apostrophes around them,

e.g. Instead of this: DB('Cube', !Version, !Year..);
the rule had this: DB('Cube', !'Version', !'Year'..);

I must admit it completely escaped me that you could do this, but I was wondering, is there any advantage to using the single quotes?

Maren
User avatar
jim wood
Site Admin
Posts: 3968
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 575 Washington Blvd Jersey City NJ USA
Contact:

Re: Single Quote around DB rules

Post by jim wood »

It was probably put there in older versions to handle dimension names with spaces. I doubt there is any kind of benefit.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply