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...

Hey FLB, Attached is the expression in my "Rank Metric". I forgot to mention before, that my Database is SQL Server. Please check the syntax and see if I am still doing something wrong. When I try the statement below, I still get the error "Object of (type: Attribute) not allowed in this...

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,

Hey FLB, I tried to build the rank metric as you had asked me to but there is a minor problem here. MSTR does not allow me to put an Attribute in a case statement in the metric editor. Any ideas if there is a workaround for this. Thanks,

FLB, Thanks a lot for the prompt reply. I could get everything but the Relationship Filter Part. When you said "set of days" in the "Advanced Qualification" does the "days" refer to the "Day Attribute". Please let me know. Once again, thank you very much

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,

Thanks a lot for your prompt response. The issue is that the Custom Group is not made up of just one Attribute. Any more ideas?

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...