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
3 answers

get a mutating url with javascript

i have the following question: i'm currently working with a software(MicroStrategy, BI) wich has a functionality that exports reports to pdf, it works something like this: each report has an unique ID, so you select the report to export, and with…
1
vote
1 answer

Connecting microstrategy to Hive

I have trouble connecting microstrategy to hive. I have followed every instruction here I have read technical notes from microstrategy as well. I can connect successfully to port 8020, but when i run the query i get SQLget error. I am not able to…
RFT
  • 1,041
  • 4
  • 13
  • 25
1
vote
0 answers

Issue with metrics which calculates my N-1 values, when adding date or week attributes to my cube in Microstrategy

I have a cube that contains several attributes and metrics, including a metrics that calculates quantity and values of this year and last year. The metrics works perfectly when I have year and month as attributes of time, but when I'm adding date or…
Philippe
  • 11
  • 2
1
vote
0 answers

How to make cosmetic changes in MicroStrategy Web without the SDK

I am working on a MicroStrategy website and would like to make some changes to the look of the site in order to customize it for my company. However, I do not have access to the SDK or the Customization Editor. All of the documentation that I've…
timmy a
  • 21
  • 2
1
vote
1 answer

how to trigger event in MicroStrategy using api

I have a requirement where I have to run a MicroStrategy trigger which i need to run after a SQL job completes. What are options I can use and if I want to run this code what details needed. i have gone through a link…
1
vote
0 answers

Mstrweb getting newWindow is undefined

I am using mstrweb microstrateg, without any change I am getting the error like bone-global.js?v=-1689619172:1 Uncaught ReferenceError: newWindow is not defined at microstrategy.submitForm (bone-global.js?v=-1689619172:1:291538) at…
zul norrain
  • 11
  • 1
  • 5
1
vote
0 answers

Microstrategy Library server using wrong hostname

An error has occurred with the Intelligence Server. The following error was encountered while trying to retrieve the URL: http://servername279.asd:34962/api/bulkreadobjects Unable to determine IP address from host name servername279.asd This is the…
Silex
  • 11
  • 1
1
vote
1 answer

Is it possible to add 2 rows of header to a Microstrategy Dossier?

in Microstrategy Dossier, is it possible to create 2 rows of header, such that the first row is the grouping information and spans to number of columns to identify as a group? for example : group "Inbound costs" should span to "Dep1 | Dep2 | Dep3"…
kayhan yüksel
  • 378
  • 2
  • 9
  • 24
1
vote
0 answers

Is there a function that does the same thing as an INNER JOIN in MicroStrategy?

MicroStrategy-I need to do an INNER JOIN starting from the IF condition of an attribute that I created. I need to prioritize the true condition of the if when the same id repeats itself and ends up fulfilling both conditions of the if.
1
vote
0 answers

MicroStrategy: Creating a table from multiple count(metrics) from different datasets

I'm trying to create a MicroStrategy document that has data from four freeform SQL reports. All of the freeform SQL reports would have the following format. Status count(case) Pass 40 Fail1 50 Fail2 60 Now, I'm trying to create a…
ItsMeGokul
  • 403
  • 1
  • 5
  • 16
1
vote
1 answer

Microstrategy: Force metric level. Attribute + Report level

In order to get the correct value from an invoice, we need to force this calculation at the attribute 'Invoice ID' level and Report level aswell. At this moment, we added this atribute to dimensionality but the SQL generated by the report is not…
Shaderlolz
  • 11
  • 1
1
vote
0 answers

MicroStrategy REST API 2021 Cube Datasource / History

I've been digging through the 2021 MicroStrategy API trying to find a few specific things. Hopefully someone knows where I could find the data, or just tell me it's not there so I can stop looking. This is what I'm looking for: I'm looking to be…
wymangr
  • 189
  • 3
  • 16
1
vote
1 answer

Snowflake ODBC setup for AzureAD authentication for MicroStrategy Server

We're using MicroStrategy on-premises to access a warehouse in Snowflake. All the users connecting to Snowflake are authenticated through Azure AD. We want the same for MicroStrategy instead of using a local Snowflake account. Is that…
1
vote
2 answers

Apache Jmeter is not giving any error even we gave wrong credentials

I am new to JMeter. I am using it for load testing for Microstrategy web dossiers. I am loading the users from CSV Config file. I have generated steps using Badboy software and exported as Jmeter file. I have added variables for userID and password.…
Rakesh Devarasetti
  • 1,409
  • 2
  • 24
  • 42
1
vote
2 answers

Tomcat Start on Reboot: init.d script unsuccessful

I need to have tomcat start after a reboot of the linux OS. I cannot get init.d to function properly through reboot. OS and Versions: JRE: 1.8.0 JAVA: 1.8.0 Tomcat: 8.5.34 Linux: Amazon Linux 2 ****ALL STEPS COMPLETED AS ROOT TOMCAT Deployment…
Mason Wood
  • 23
  • 1
  • 6
1
2
3
18 19