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!

  • Congratulations Mike Lewis 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. NoobieRhyme

    Misalignment from Web to PDF

    Hi! I am having problem with the alignment. I have a grid in a document that does not display consistently in place. The grid may be aligned with other text objects in Web already but when it's viewed in PDF, the objects are not aligned anymore with respect to the grid columns. Is there a...
  2. NoobieRhyme

    Filter on Metrics of Logical View

    I have created a Logical View to customize outer joins and running totals. Its attributes and metrics run on the report correctly but the problem occurs when I use a filter on the metric that uses the logical view. The logical view statement is repeated with a duplicated identifier name...
  3. NoobieRhyme

    rows to columns

    Hi! I really cant figure this out. Help Please. I have data: Item Class Name ============================= 1 A Name1 1 B Name2 1 C Name3 2 A Name4 2 B Name1 2 C Name6 3 A Name3...
  4. NoobieRhyme

    Embed picture in a document

    How can we embed the image in a document such that it is still visible when the report is downloaded as pdf?
  5. NoobieRhyme

    RunningSum Breakby

    Thanks! Is it possible to have a running total ignoring the filter? Product Day Sales Count Running Sales Count A 8/1/05 10 10 8/2/05 12 22 8/3/05 3 25 B 8/1/05...
  6. NoobieRhyme

    outer join - per date

    wow...it's working!...thank you very much...i wonder if i'm still allowed to make extra question.. I add a column to Table A and the Table B remains the same. Item Expiration Date ============================ x 8/18/2005 y 9/01/2005 z 9/01/2005 Now we...
  7. NoobieRhyme

    outer join - per date

    Thank you very much amrita...however, it's not yet working. the two "select" works fine separately but when the two is "union-ed", the return takes too long that i didnt wait anymore...but i believe it's getting near. vongrunt, what I need for now is for dates that exist in table B. But i'm...
  8. NoobieRhyme

    outer join - per date

    Hi. I have an example here for my sql question. TABLE A: Item ====== x y z TABLE B: ITEM DATE COUNT =========================== x 8/17/05 34 y 8/17/05 4 x 8/18/05 76 y 8/19/05 3 I wanna have a daily inventory of the items...
  9. NoobieRhyme

    Prompts/Filter options

    Select x1.column1 from Table1 x1 where x1.column1 > (Select x2.column1 from Table x2 where x1.column1 = 5) ============================================ the last clause parameter "x1.column1 = 5" is the result of a prompt entry. but is it possible that the the prompt uses the table x2...
  10. NoobieRhyme

    Prompts/Filter options

    Hi! May I ask question on the Prompt/Filter capabilities: 1. I have a prompt that a user can select one of the listed elements. Is it possible to have a filter that an attribute can apply comparison filter between the attribute and selected element? For example I have a list of levels, (1...
  11. NoobieRhyme

    Connect to MySQL

    Is it possible to connect to MySQL Database from MicroStrategy? How, please? The MySQL database connection type seems to be not unavailable from the list. Thanks!
  12. NoobieRhyme

    RunningSum Breakby

    Help please with the Running Sum. I have a "Product" & "Day" Attribute, and "Sales Count" & "Running Sales Count" Metric. My Current Report displays the following: Product Day Sales Count Running Sales Count A 8/1/05 10 10 8/2/05...
  13. NoobieRhyme

    MicroStrategy's logic for Fact Table Auto-select

    Hi. I am a new to MicroStrategy, especially with Project Designing. Hope you bear with me. I have a fact that has been mapped to many fact tables. Now I'm curious how the MicroStrategy automatically select which table best fit to a certain report. Anyone knows? Thank you very much.

Part and Inventory Search

Back
Top