EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB310430: Hints and comments in SQL Statement are ignored through Data Import in MicroStrategy Web


Community Admin

• Strategy


Hints and comments in SQL Statement are ignored through Data Import in MicroStrategy Web 10.2-10.x

SYMPTOM:
Hints and comments in SQL Statement are ignored through Data Import in Strategy Web 10.2-10.8
STEPS TO REPRODUCE:

  1. Click on 'Create' button to create a new dashboard in Web
  2. Click on "Add External Data"
  3. Click on Database option
  4. Select "Type A query option"
  5. Provide a SQL script with Hints or comments. Below script as an example:
    
    select /*+ PARALLEL(4) */
    PROP_VAL
    from YEF6SEP21U19.DSSCSSYSPROP;

  6. Click on Execute SQL. Expected behavior is query should run in database with parallel hint, while the query is actually skipping the Parallel hint.

CAUSE:
This is a known issue in Strategy Web 10.2.
ACTION:
Currently this issue is being reviewed by our Technology team. Please contact Strategy Technical Support for an update on this issue.


Comment

0 comments

Details

Knowledge Article

Published:

June 9, 2017

Last Updated:

June 9, 2017