Creating reports in MicroStrategy Developer

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

To create reports in MicroStrategy using the Kyvos tables, perform the following steps.

Open the MicroStrategy Developer.
In MicroStrategy Secure Enterprise, click the Create New Project option or use an existing project.
Enter a Project Name in the corresponding field and click OK.
On the displayed Create New Project, enter details as:
1. Warehouse Database Instance: This is the warehouse database instance, as selected from the Warehouse Database Instance drop-down list. There can only be one Warehouse Database Instance for a project because this database instance’s data is populated in the Warehouse Catalog to define the project’s relational schema. Click OK.
2. Warehouse Catalog: From the Schema menu, select the Warehouse Catalog option. The Warehouse Catalog opens after it retrieves the table information from the Kyvos database. The Warehouse Catalog queries the data from Kyvos and lists the tables and columns that exist in it. From this list, you can select the tables to add to your project. Every project can have a unique set of warehouse tables.
3. Table Prefix: Allows you to add or remove a table prefix for the selected table. right-click and select the Table Prefix option. Choose the relevant prefix of the Kyvos Folder/Database.
4. To create facts with the Fact Creation Wizard: Click Define Rules to set some basic fact creation rules. The Fact Creation Rules page opens. Rules help automate and govern the fact creation process. If the naming conventions in your warehouse do not conform to the defaults in the Fact Creation Rules page, you may need to change these rules. Select Numeric and leave the remaining checkboxes cleared.

Important

You must clear the Replace underscores checkbox in the fact name with spaces. Else, the MicroStrategy generated SQL Syntax does not support the Spark/Kyvos SQL slandered.

To create attributes using the Attribute Creation Wizard

In the Project Creation Assistant, click Create attributes. The Attribute Creation Wizard is displayed, which helps create attributes. The Column data type area allows you to select the column data types to be available as possible attribute ID columns. Select the checkboxes for the data types that should be included when the wizard searches the data warehouse for available attribute ID columns.

Notes

To successfully create and run the created attributes, consider the following as per Kyvos requirement

Clear the Replace underscores checkbox in the attribute name with spaces.
Clear the Remove the word “ID” from the name checkbox.
Clear the Capitalize the first letter checkbox.

After you have completed the steps of the Fact and Attribute Creation Wizard, you can start creating your reports.