MicroStrategy CREATE REPORT statement syntax
Trying to create a bunch of MicroStrategy reports via code (instead of manually going through the GUI). Does anyone have a working CREATE REPORT statement?
Here's an example of a working CREATE ATTRIBUTE statement:
CREATE ATTRIBUTE "attrib1" DESCRIPTION "attrib1"
IN FOLDER "\SCHEMAObjects\ATTRIBUTES\attrib1"
HIDDEN FALSE ATTRIBUTEFORM "attrib1" FORMDESC "attrib1"
FORMCATEGORY "ID" FORMTYPE NUMBER EXPRESSION "[attrib1]"
EXPSOURCETABLES "attrib1_table"
LOOKUPTABLE "attrib1_table"
FOR PROJECT "Someproject";
Just looking for a version of this for CREATE REPORT. Can't seem to find it on googles or in the documentation.
Unfortunately it's not possible to create a report using MicroStrategy Command Manager.
As you can see from the Outline window below (this shows all possible outlines in Command Manager with code samples) for you can list your reports, delete them or alter some properties of your MicroStrategy Reports.
As you can see from the outline for the ALTER REPORT command what you can modify is pretty limited, you can enable/disable cache, hide or un-hide a report, change the description or the long description, move a report to another folder.
If you want to create a report from scratch using code you need to use MicroStrategy SDK. You can start from this TechNote: TN38166: How to Create a Report and Filter Expression from Scratch Using the MicroStrategy Web SDK 9.2.x and 9.3.x.
- How to initialize 2D ArrayList in Java?
- Dynamically averaging data Per ID Per Time period Alternate Version
- How to deal with a list of EF database first contexts and cast them correctly?
- C# winforms combobox dynamic autocomplete
- Create, modify, disable multiple CSS rules by ID with JavaScript
- VBA Code to filter a table and all its columns, whilst typing and ignoring accents
- Dynamic s:form action
- How do I call a dynamically-named method in Javascript?
- Python concatenation dataframes if they exist
- ExtJS 6.2: Add afterLabelTextTpl Dynamically
- Why am I encountering this "#VALUE error" when using BYROW, LAMBDA and INDIRECT function together?
- Creating and using dynamic variables based on a dynamic component
- C# dynamic compilation of string and .cs file
- Protected memory violation when executing method from dynamically loaded assembly
- How do I only draw the top part of a circumference?
- C++ Dynamically allocated std::vector
- How to create a Formgroup using an interface in Angular
- How to compile Qt plugins statically and dynamically
- Can search engines index JavaScript generated web pages?
- Extracting data from a dynamic website using selenium
- Why does this (null || !TryParse) conditional result in "use of unassigned local variable"?
- Why do I get this compile error trying to call a base constructor/method that takes a dynamic argument?
- Lots of first chance Microsoft.CSharp.RuntimeBinderExceptions thrown when dealing with dynamics
- Does awk support dynamic user-defined variables?
- Why do trait object vtables contain size and alignment?
- dynamic row numbering after add/delete using jquery
- LINQ and dynamic queries with paging and without LINQ2SQL
- Error 'A value of type 'dynamic' can't be assigned to a variable of type 'String'.' in Dart 2.2
- ASP.NET Core 8 Web API with OData
- How do I access dynamically created objects and their properties in JavaScript?