How do I create a SQL query in MicroStrategy?

Posted on by Author

How do I create a SQL query in MicroStrategy?

In MicroStrategy Developer, on the File menu, point to New, and choose Report. The New Grid dialog box opens. On the Freeform Sources tab, select Create Freeform SQL report. In the Source area, select a database instance for the database to access using Freeform SQL.

What SQL does MicroStrategy use?

SQL Server 2017 is supported in MicroStrategy 2019.

Can you write SQL in MicroStrategy?

Freeform SQL and Query Builder provide two alternative methods to access your data and begin analysis with MicroStrategy. Freeform SQL allows you to write your own SQL statements to run directly against a data warehouse or operational data store, giving you full control over accessing your data.

How do I get SQL report from MicroStrategy?

To see the SQL for a report in MicroStrategy Web, from the Tools menu select Report Details Page. The SQL is displayed in the SQL Statement area. Click Show Advanced Details below the SQL Statement area to see execution statistics for the report.

READ:   What are HUD rules?

How do you import a query?

If you want to import queries, click the Queries tab and select the queries you want to import. To cancel a selected object, click the object again. Click Options to specify additional settings.

Is Power Query similar to SQL?

When connecting to SQL DB, Power Query tries to do Query Folding and tries to push maximum logics to data source, means the time take in Power Query and SQL will be the same in such cases. In your example, ideally Power Query should just trigger a SQL with a where clause for the time filter.

What is query folding?

Query folding is the ability for a Power Query query to generate a single query statement to retrieve and transform source data. The Power Query mashup engine strives to achieve query folding whenever possible for reasons of efficiency.

What is MicroStrategy Desktop?

MicroStrategy Desktop is a powerful data discovery tool for anyone in your organization that lets you explore data and answer questions on your own. By reimagining the data discovery process, we made it easier than ever for analysts and citizen data scientists to visualize data.

READ:   Is Adfly good for making money?

https://www.youtube.com/watch?v=XUMo5l4YSaU