Stack Overflow
Stack Overflow

Questions tagged [microstrategy]

MicroStrategy is a proprietary business intelligence suite based on a ROLAP back-end similar to Cognos or Business Objects.

MicroStrategy is a proprietary business intelligence suite based on a ROLAP back-end similar to Cognos or Business Objects. Key features include a ROLAP engine with a metadata based database markup system, in-memory OLAP based on the metadata, ad-hoc reporting and analytic tooling aimed at power user skill levels, a dashboard builder/publisher, and a portal facility providing a front-end.

Competitors include Business Objects, Cognos and ROLAP tooling supplied by database vendors such as Microsoft and Oracle. MicroStrategy do not provide a dedicated MOLAP server, although the tool does have a proprietary in-memory local cube facility. The suite does not support native browsing of third-party OLAP servers, although it can import data from OLAP sources and use it witin its own metadata layer.

Use this tag for any questions related to the MicroStrategy tool chain.

284 questions
1
vote
1 answer

How to create a user using microstrategy SDK in java (External Security Module)

My goal is to create user using microstrategy SDK and assign filters and groups to the user. I have a java class CreateUser & SSOESM from SDK. Do I have to create a plugin of the create user class and deploy it in microstrategy intelligence…
Karuna
  • 719
  • 1
  • 11
  • 22
1
vote
2 answers

Microstrategy Web API - JAVA SDK

I am developing something with Microstrategy JAVA SDK. But I am not getting the com.microstrategy.webapi.serverinfo class. Can any one tell me which .jar file I am missing Thanks, Surodip
Surodip
  • 457
  • 1
  • 8
  • 21
1
vote
1 answer

microstrategy join uncommon attribute

I'd like to make a report that relate: 2 metric from two distinct fact table 1 attribute (from a Lookup table) common to both fact table 1 attribute (from another Lookup table) that is present in only one fact table In my environment,…
Marco Giaccari
  • 21
  • 4
1
vote
3 answers

How to prevent Microstrategy from pulling all data

We are building a dashboard with many reports. The relationship between tables is defined in microstrategy. We found that Microstrategy is not using different SQL for different reports. It is pulling all the data from Database(which is 46 million)…
Luniam
  • 463
  • 7
  • 21
1
vote
1 answer

Calling a js file within a microstrategy report

i need to call javascript code from a js file to add a dynamic url to a link within my report, i've tried to use a html container to do just this: But…
Bruno Gomes
  • 13
  • 6
1
vote
1 answer

Microstrategy 9.x - formatting column (metrics and attributes) headers in document grid/graph

I have a document with several grid/graps objects (all in grid visualization). I need to chage the color of the columns headers. In the picture they are black. I cannot find a way to make them red as the grid header If i try to rigt clic on an…
AndreA
  • 779
  • 9
  • 22
1
vote
0 answers

Microstrategy Training metric creation

I am just trying to create a report with basic predictions. I have created a Freeform SQL report with the following query: select Customer_ID, Month, Sum(Amount) as Amount from Transactions group by customer_ID,MRR_Month_DT I have declared…
Karthi
  • 708
  • 1
  • 19
  • 38
1
vote
0 answers

Ntile usage in microstrategy

I need to compare last year sales and current year sales based on quintile score and should divide all the customers into 1,2,3,4,5 buckets using NTILE function. Also need to include 2 more columns(old,new) in the report. Old indicates customers who…
Vinutha Pinthepu
  • 11
  • 2
1
vote
0 answers

Hortonworks ODBC driver does not apply server-site property

I've installed ODBC Driver from http://hortonworks.com/hdp/addons/ and configured to use my Hive Server 2 on HDP installation. I'm using Microstrategy Microstrategy Analytics Desktop to run queries. It works fine, until I'm trying to use server…
psmith
  • 1,769
  • 5
  • 35
  • 60
1
vote
0 answers

Microstrategy Table Selection

I have a problem. I have made 2 fact tables, which are almost identical - they only have 1 attribute and 1 metric in report. Now, there are 3 Attribute Qualification Prompt in the report 1 required 2 optional. Table A has all 4 attribute mapped(3…
Amit
  • 11
  • 3
1
vote
1 answer

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"…
Artem Cherkes
  • 79
  • 1
  • 2
  • 8
1
vote
1 answer

Microstrategy Clustering and licences

I have two registered instance of MSTG 9.3 suite, both with 10 named user licences. I have used one in testing and second in production purpose. I want to create MSTG cluster. Would I get 10+10 named user licences or I will 'lose' 10…
fenix
  • 1,716
  • 2
  • 20
  • 26
1
vote
1 answer

Calling Stored Procedures from Microstrategy

We have a stored procedure that takes in a set of parameters (from dimension tables) and then outputs a set of rows from which a report has to be created. Till now this is done in a .NET app using an ORM, but is it possible to integrate it with…
ganeshran
  • 3,512
  • 7
  • 41
  • 69
1
vote
2 answers

MicroStrategy - Dynamic Attribute with join

In our MicroStrategy 9.3 environment, we have a star schema that has multiple date dimensions. For this example, assume we have a order_fact table has two dates, order_date and ship_date and an invoice_fact table with two dates invoice_date and…
Nick
  • 2,524
  • 17
  • 25
1
vote
2 answers

How to make Microstrategy to work with user schema in Redshift / psql tables?

I use Amazon Redshift with MIcrostrategy. In Microstrategy i can see properly all tables from public schema. When I created my own schema, however, Microstrategy "sees" the tables, but does not see the fields inside them (i.e. when I click on a…
user3058079
  • 21
  • 1
  • 4
1 2 3
…
18 19