Search results for query: *

Hi, I have a problem and would sincerely appreciate any earliest solution or workaround. I have a report with the following specs - Row Attribute - "Region",Metric: Sales $,Page-By - "Store" Note that Region can be drilled to District to Store. In the given specs, we have to keep "Store" in...

Hi, In my report, I have the row attribute as "Year" off of the Time hierarchy, which can be drilled to Year->Quarter->Month->Week->Day. I have a metric on the report as "Sales $" and "LY Sales $". First metric can be calculated easily. Problem is hot to build the second metric "Last Year...

Hi, I have a requirement, where in, in the attribute "Class" a part of the Page-By section. It has 10 distinct codes, and we want to add "No Selection" as a 11th value in the list. Scenario would be - if user selects "No Selection", then there will not be any "Class" filter selection to be put...

Hi, 1) I have Location and Product hierarchies such as: Location: Corp->Div->Region->Dist->Loc Product: Dept->Class->SubClass->Prod 2) Have two fact tables : fact1 and fact2, and columns are fact1: Week, Div, Class, Amt [Lowest level of granularity] fact2: Week, Div, Prod, Amt [Lowest level...

Hi, I need to write a custom HTML for custom page footer- based on the Report file name (&Report) in MSTR Web 7.5. For example - if the Report Name is "RPT11 - MSTR Report" - then the custom Page footer should display "RPT11", i.e., first 5 (fixed #) characters off of...

Hi, I have a requirement, where in, in the attribute "Class" a part of the Page-By section. It has 10 distinct codes, and we want to add "All" as a 11th value in the list. Scenario would be - if user selectes "All", then there will not be any "Class&quot...

Hi, We are on MSTR Rel 7.2.3. I understand that, we can drill from report to template. We have certain specific needs which needs to be addressed. We are open for any effort at this level. The needs are 1) Drill from report to document, which has another report ? 2) Drill from document to...

Hi, I understand that there is a way to run a database procedure through Pre/Post Statements. Question is how to pass the report parameters (user prompt values) as arguments to the procedure. It doesn't matetr to me whether I use "Pre" or "Post" sections. So, any tip would...

Hi, I am on MSTR 7i - 7.2.1. Have a special rqmt. Have to use DM Report (dm report) as a report filter in another report (2nd report). While running the 2nd report, in which one of the metric is using dm report as a report filter, we want the dm table to be populated also. But, it's not...