function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
gueropolkasgueropolkas 

Integration: SFDC and MicroStrategy

I am trying to use MicroStrategy as an analytical reporting engine for SFDC.    I can report on some objects, but stumble on cases;  MicroStrategy's SQL interpreter considers "case" to be a reserved keyword.    Does anyone have a work-around for this?   I would love to hear from a fellow MicroStrategy user.

Go! GetterGo! Getter
Hi!! I think I can help. Would you like to set up a call to discuss? Please email me at scottblau@statusgonow.com. Thanks!! Scott
Rahul_sgRahul_sg
try [case].
If you "quote" the table name it should work. The default quotes in SQL server are square brackets: []
gueropolkasgueropolkas

Rahul,

 

You rock!   The quotes work, the brackets not.   But thanks for pushing me over the hurdle.   

 

Dan