KB440199: "Limitation: The document can not include a prompt" returned with MicroStrategy Command Manager 10.x

Senior Cloud Support Engineer III • MicroStrategy

This article explain about the error returned by MicroStrategy Command Manager when LIST ALL PROPERTIES FOR DOCUMENT... executed for the document with a prompt and suggest a workaround.

SYMPTOM
When executing a following outline with Strategy Command Manager 10.x, an error message returned after "Syntax is correct." shown:
LIST ALL PROPERTIES FOR DOCUMENT "Test" IN FOLDER "\Public OBJECTS\REPORTS\" FOR PROJECT" Strategy Tutorial";


Limitation: The document can not include a prompt
Task(s) execution completed with errors.

CAUSE
This is a limitation with Command Manager 10.x. "LIST ALL PROPERTIES..." does not work with documents defined with one or more prompts.
ACTION:
Use the following Command Manager command to retrieve properties from prompted documents:


GET PROPERTIES LONGDESCRIPTION FROM DOCUMENT "My Document" IN FOLDER "\My Folder Path" FOR PROJECT "My Project";

You can also consider utilizing an Enterprise Manager report called "51.3 Document Properties" located at:


\Enterprise Manager\Public Objects\Reports\Project Analysis\Object Properties Analysis

Create a copy of this report and "Report" and "Prompt" objects to confirm which report is used as a dataset of the document and what prompt objects are used there. SQL for the report will be generated as follows:


select    distinct a13.IS_DOC_ID  IS_DOC_ID,
    a15.IS_DOC_NAME  IS_DOC_NAME,
    a12.IS_REP_ID  IS_REP_ID,
    a14.IS_REP_NAME  IS_REP_NAME,
    a11.IS_PROMPT_ID  IS_PROMPT_ID,
    a11.IS_PROMPT_NAME  IS_PROMPT_NAME
from    IS_PROMPT    a11
    left outer join    IS_REP_PROMPT    a12
      on     (a11.IS_PROMPT_ID = a12.IS_PROMPT_ID)
    left outer join    IS_REP_DOC    a13
      on     (a12.IS_REP_ID = a13.IS_REP_ID)
    left outer join    IS_REP    a14
      on     (a12.IS_REP_ID = a14.IS_REP_ID)
    left outer join    IS_DOC    a15
      on     (a13.IS_DOC_ID = a15.IS_DOC_ID)

Note: IS_REP_PROMPT and IS_REP_DOC are relationship tables. For more information about tables in Enterprise Manager warehouse, refer to Enterprise Manager Data Dictionary
KB440199

Comment

0 comments

Details

Knowledge Article

Published:

March 20, 2018

Last Updated:

May 29, 2020

select distinct a13.IS_DOC_ID IS_DOC_ID, a15.IS_DOC_NAME IS_DOC_NAME, a12.IS_REP_ID IS_REP_ID, a14.IS_REP_NAME IS_REP_NAME, a11.IS_PROMPT_ID IS_PROMPT_ID, a11.IS_PROMPT_NAME IS_PROMPT_NAME from IS_PROMPT a11 left outer join IS_REP_PROMPT a12 on (a11.IS_PROMPT_ID = a12.IS_PROMPT_ID) left outer join IS_REP_DOC a13 on (a12.IS_REP_ID = a13.IS_REP_ID) left outer join IS_REP a14 on (a12.IS_REP_ID = a14.IS_REP_ID) left outer join IS_DOC a15 on (a13.IS_DOC_ID = a15.IS_DOC_ID)