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

KB45799: Any changes on Freeform SQL report reset the ACL of the component logical tables in MicroStrategy Developer 9.4.x-10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


In MicroStrategy 9.4.x-10.x, the user has customized ACL of a logical table that used by a Freeform SQL report. But any changes to the Freeform SQL report will reset the ACL for the logical table

SYMPTOM:
In Strategy 9.4.x-10.x, the user has customized ACL of a logical table that used by a Freeform SQL report. But any changes to the Freeform SQL report will reset the ACL for the logical table.
STEPS TO REPRODUCE:
The following steps are performed in Tutorial Project.

  • Create Freeform SQL using following statement.
    Sql
    select CATEGORY_ID from LU_CATEGORY;
  • Search component object of the Freeform SQL report. In the opening Search box, go to Tools -> Options, check option "Display Managed Objects" and "Display hidden objects".
ka02R000000kX5KQAU_0EM440000002CVk.jpeg
  • A logical table is searched out. Right mouse click table and select Properties -> Security. 
ka02R000000kX5KQAU_0EM440000002CVl.jpeg
  • Set the Security : Everyone - 'Full Control'.
ka02R000000kX5KQAU_0EM440000002CVm.jpeg
  • Open the Freeform SQL and change the SQL.
  • Repeat step 2-3, notice that list turns to be empty. The ACL has been reset.
ka02R000000kX5KQAU_0EM440000002CVj.jpeg

CAUSE:
This is a known issue in Strategy Developer 9.4.x-10.x.
 
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.  


Comment

0 comments

Details

Knowledge Article

Published:

April 10, 2017

Last Updated:

April 10, 2017