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

KB31477: “Cannot delete ‘PromptName’ because other objects depend on it. Do you want to search the dependent objects?” message is seen when trying to delete a prompt however no results are returned in MicroStrategy Developer 9.4.x-10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This article discusses a current limitation of Freeform SQL reports which don't show up when searching for dependencies on prompts

SYMPTOM:
When trying to delete a prompt in Strategy Developer 9.4.x-10.x the following message is seen:

ka04W000001IqcPQAS_0EM440000002EIP.jpeg

 
The subsequent search for dependent object shows no objects even if managed objects are set to be displayed.
However, no dependencies appear in the search results.   
 
STEPS TO REPRODUCE:
Execute the following in Strategy Tutorial:

  1. Create a new value prompt.
  2. Create a new Freeform SQL report.
  3. In the Freeform SQL definition select Insert a Prompt from the file menu and select the value prompt created in step 1.
  4. Save and close the Freeform SQL report.
  5. Attempt to delete the prompt created in Step 1 and you will receive a warning message that the prompt cannot be deleted, however the FreeForm SQL report created will not show up as a dependency. 

CAUSE:
This is a known issue in Strategy Developer 9.4.x-10.x.
The prompts used in Freeform SQL Reports are part of the report's definition.  Currently, prompts part of a Freeform SQL definition do not show as dependent objects on the report when doing a search in Developer.
 
ACTION:
Users who wish Freeform SQL reports to be returned in such search are invited to request this via the Ideas Exchange: https://community.strategy.com/topic/0TO44000000Flj5GAC/developer-u237?tabset-215d6=4aa55
Related KB article: KB31656: Cannot delete prompt because other objects depend on it but dependency search returns empty in MicroStrategy Developer 9.4.x-10.x


Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

July 14, 2017