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

KB46107: When bursting on a Freeform SQL report, is it possible to use the {[Attribute Name]@[Attribute Form]} macro in the file name in MicroStrategy Web 9.3.x and newer?


Community Admin

• Strategy


When bursting on a Freeform SQL report, is it possible to use the {@} macro in the file name in MicroStrategy Web 9.3.x and newer?

QUESTION:
When bursting on a Freeform SQL report, is it possible to use the {@} macro in the file name in Strategy Web 9.3.x and newer?
 
ANSWER:
When bursting on an attribute defined in a Freeform SQL report using the Attribute Name macro in the file name, the attribute name is not displayed in the file name. The following error messages can be seen in the DSSErrors.log:


hGetAttributeIDAndFormIDByName: ERROR, cannot find attribute by name: "Reg"
hIsCurrentBurstElementsValid: group-by element is element all, skip slicing
hGetAllBurstMacroValues: ERROR, burst element array dimention mismatch. lPos=-1, lElementArraySize=1
hGetAllBurstMacroValues: ERROR, burst element array dimention mismatch. lPos=-1, lElementArraySize=1
hGetAllBurstMacroValues: ERROR, burst element array dimention mismatch. lPos=-1, lElementArraySize=1
hGetAllBurstMacroValues: ERROR, burst element array dimention mismatch. lPos=-1, lElementArraySize=1
hGetAllBurstMacroValues: ERROR, burst element array dimention mismatch. lPos=-1, lElementArraySize=1
hGetAllBurstMacroValues: ERROR, burst element array dimention mismatch. lPos=-1, lElementArraySize=1
hGetAllBurstMacroValues: ERROR, burst element array dimention mismatch. lPos=-1, lElementArraySize=1

 
Currently it is not possible to use the Attribute Name macro in the filename of a Freeform SQL report as the attribute is not in the schema.
 
ACTION:
This issue has been addressed in Strategy 9.5 and above. Please upgrade to take advantage of the fix


Comment

0 comments

Details

Knowledge Article

Published:

May 25, 2017

Last Updated:

May 25, 2017