Search results for query: *

Thanks a lot, entaroadun, for your patience. I perfectly agree with your views here, and have no question on this. Let me clarify what I meant by "Total or SubTotal" on Store (v2) attribute. While defining a report - I have put Region in row, and metric in column, and Store (v2) in Page-By...

Thanks a lot entaroadun, Good and Clean approach. I am sure I would have missed out in my explanation somewhere. Let me re-explain this issue - Let me go back to your old approach with the attributes stuff - While you are on the Region report, and have Store(v2) in the Page-By, and Store (v2)...

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

Thanks a lot, nlim. Appreciate your kind help in this matter. Would you mind giving some tips on thread395-783680. - which is "Custom Page Footer for MSTR Report based on the Report File Name".

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

Dear Nlim, Thanks for the prompt response ! I tried turning on "Total" - I can't see "Total" or "All" added as another code value in the "Page-By" attribute selection. Whis is what we wanted.... Please note that as explained in the problem above, users...

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

Thanks, nlim, My requirements wouldn't be fullfilled by using procedure in a metric. I do not have any option other than using it in a pre-post statement. Do you think there could be a alternate way of grabbing user prompt parameters values and pass them along to the database procedure. Any...

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