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
0
votes
1 answer

Microstrategy filter a column

I have this table : Date Person Usable 20140101 AAA TRUE 20140101 AAA TRUE 20140101 AAA FALSE 20140101 BBB FALSE I want to display the count of usable and the count of not usable filter by date and…
Fabrice Mainguené
  • 486
  • 1
  • 5
  • 18
0
votes
2 answers

Microstrategy vs SSAS

A sample Dimension table structure is given below for reference. CREATE TABLE [dbo].[DimDoctor] ( [skDoctorKey] [int] IDENTITY(1,1) NOT NULL, [DocCode] [char](9) NOT NULL, [FirstName] [varchar](30) NULL, [lastName] [varchar](30)…
Jithin Shaji
  • 5,893
  • 5
  • 25
  • 47
0
votes
1 answer

How to externalize the authorization of Microstrategy

Is there way to externalize the Microstrategy permissions in to XACML based authorization system? I guess, Microstrategy must have some kind of handler (or extension point) that can be implemented to call the Authorization system. Does Microstrategy…
Asela
  • 5,781
  • 1
  • 15
  • 23
0
votes
1 answer

Microstrategy - Unable to calculate the difference between two dates related by fact table

We are trying to calculate the difference between two dates. The scenario is the following. 3 Dimensions: DIM_DATE DIM_RELEASE_DATE (Alias of DIM_DATE) DIM_PRODUCT 1 Fact table: FT_SALES FT_SALES relates to DIM_DATE and…
Steven Yvinec-Kruyk
  • 1
  • 1
  • 2
0
votes
0 answers

How to connect with microstrategy command manager using C#

As i am new to microstrategy i need to know whether it is possible to handle Microstrategy command manager utility using C#.If possible can anyone show me the path to kick start that.
user2792115
  • 3
  • 2
0
votes
1 answer

Microstrategy - Creating 3 selectors on the same attribute

I have a requirement of comparing Product line (attribute) and Brand (Attribute) using 3 different selectors. Product line and Brand is having one to one relationship . My dashboard should look like below.(sorry I cant attach the snapshot) Prod line…
Sagar
  • 26
  • 2
0
votes
2 answers

Microstrategy filter data by today's date

I am trying to filter data from Microsoft SQL in an intelligent cube by today's date. The format of the date from the database is YYYY-MM-DD HH:MM:SS. I want to include all of today's date regardless of the time. This is the filter I have…
user2877197
  • 1
  • 1
  • 1
  • 5
0
votes
2 answers

Force Microstrategy to use specific table in join

Sometimes, when I am creating reports, Microstrategy takes the wrong table for join (in case of using fields in report that appear in more than one table). For example if I have fact_table and fact_table_month, and they have the same fields,…
user3058079
  • 21
  • 1
  • 4
0
votes
2 answers

SQLCODE -1334 on DB2 when trying to connect using MicroStrategy

I am wondering if anyone has ever encountered the following error when trying to connect to a DB2 database: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [HY000:-1334: on SQLHANDLE] [MicroStrategy][ODBC DB2 …
user2933300
  • 3
  • 2
0
votes
1 answer

How to uninstall hive 0.11.0 on amazon and install 0.9.0

I am working on a POC with Microstrategy 9.3.1 and hive 0.11.0. Recently I learnt that Microstrategy does not support 0.11.0. I have Hive running on Amazon. Now, I need help to uninstall hive 0.11.0 in Amazon and install hive 0.9.0. Pls help…
user2893645
  • 1
0
votes
1 answer

Configuring Cloudera Connector for MicroStrategy

I have installed ClouderaHiveODBCSetup_v2_00 on my windows XP and I am following instructions as per the following page https://ccp.cloudera.com/display/con/Cloudera+Connector+for+Tableau I am get the following error the setup routine for the…
The good the bad the ugly
  • 165
  • 3
  • 5
  • 15
0
votes
2 answers

Prompt default value in Microstrategy Mobile

I have a simple mobile document in Microstrategy Mobile, running on IPhone, containing a table of values and a drop-down selector that filters those values. Is there any way to set the default value of the drop-down selector? If yes, is there any…
Marius
  • 23
  • 5
0
votes
1 answer

How to use Yammer RSS in Microstrategy

I am trying to integrate Yammer RSS into Microstrategy Dashboard, but I could not find Yammer RSS feed URL that I can use. Does anybody know the feed URL that can be used in MSTR? Thank you Grace
Grace Gu
  • 1
  • 1
0
votes
1 answer

How do I graph subtotals in Microstrategy

We're just getting started with Microstrategy and have created a few reports. One of the reports I'm working on needs to be a grid/graph and I'm struggling with how to get the graph to display what we need. Our Grid report looks like this:…
CraigBob
  • 147
  • 1
  • 5
  • 15
0
votes
1 answer

JQuery event to detect after page update

I am working on JQuery where I got a page which is already developed by other team. My task is to change headers(titles) of the tables to some specific values. So I did this easily with simple JQuery code in document.ready() event. But as I said…
Pratik
  • 831
  • 2
  • 8
  • 13
1 2 3
…
18
19