Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ArunKKK

    URGENT - Fact Extension versus "Total" in Page -by Attribute

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

    URGENT - Fact Extension versus "Total" in Page -by Attribute

    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)...
  3. ArunKKK

    URGENT - Fact Extension versus "Total" in Page -by Attribute

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

    "Time" Drill as Row Attribute with "Last Year Sales" as a me

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

    Need to display "No Selection" in the Page-By Attributes values

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

    URGENT - Metric's Conditional Calculation across two fact tables

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

    Need to display "All" with other elements of a attribute in Page-By

    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".
  8. ArunKKK

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

    Need to display "All" with other elements of a attribute in Page-By

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

    Need to display "All" with other elements of a attribute in Page-By

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

    URGENT - Can I drill from report to a document (on web) ...?

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

    MicroStrategy Datamart Report - By using it as a Report Filter

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

    Database Procedure with Report Parameters as Arguments

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

    MicroStrategy Datamart Report - By using it as a Report Filter

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

Part and Inventory Search

Back
Top