Search results for query: *

Hi, The version of MSTR is 7.2.3 and the database is SQL Server. I have a report which has an Object Prompt to select a list of Templates. The thing is that I need to have an attrbute or two in the report objects (not on the report itself). But, as the template is prompted at runtime I am...

Hi, I am a datawarehouse consultant working on the front end of the warehouse. I work with B.I tools. I do not actually do any coding in sql but would love to start off with some simple queries.( I am in a position to write some simple queries and definetly can intrepret even big queries) My...

Hi, If I am not asking for too much, I wanted to know If there is a way I could get some frequently asked Interview questions for a Microstrategy Architect/Developer position. Any help is greatly appreciated. Thanks,

Hi, I am trying to create a dynamic filter on a date Attribute to calculate 2 business days behind. For example if today is Monday then I want MSTR to calculate Thursday and so on. Any help is greatly appreciated. Thanks,

Hi, I am trying to create an Attribute based on the following logic. If "Attribute 1" is NULL then "Attribute 2" else "Attribute 1". I have tried using apply simple along with a case statement but I guess I am making a sytax error. The database being used is SQL Server. Any help is greatly...

I am trying to create a Filter on a Date Attribute which dynamically selects last Monday of last Month irrespective of the Number of Days in the Month. I am going to use this Filter in a Custom Group which has some other Elements. Any assistance is greatly appreciated. Thanks,

Guys, I have a Report which has Attribute 1, Custom Group, Attribute 2 and a Metric in that Order. The metric is a count Metric. I am creating a Derived Metric from this Count Metric to calculate the "Percent To Total". I want it to calculate at Subtotal of The Custom Group. But as the custom...