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 Chriss Miller 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. neilgalyans

    Metric Filters

    First thanks to all that have helped me thus far - it has been invaluable New question.. I have a sales table.. I need to produce a report that shows sales by item, 1 total for ALL stores, 1 total for stores that are open for more than 1 year as of the sales date the report is run. I have...
  2. neilgalyans

    Advice please - variable calculations

    Can someone give me some advice for a query I need to write.. Based on an date input from a Prompt I have built, I would like MSTR to calculate some different numbers: 1. We have a sales table that is identified with a Year,Period,Week(1-4) and Day of week (1-7) that has a column sls_amount...
  3. neilgalyans

    MSTR - Date manipulation

    GREAT -- this has been a great help. I was able to create the Metadata partitions for my sales tables. No however, I am having a hard time getting specific data from the table.. we store weekly subtotals in our database as follows: Year = 2003 Period = 10 Week = 4 Day = 0 My user will input a...
  4. neilgalyans

    MSTR - Date manipulation

    Thanks - that was a help. I have narrowed the problem down further... I have a sales table that is partitioned by year and month combinations. The query is looking at the entire table instead of hitting the partition directly. Given the attribute structure above - how do I tell microstrategy...
  5. neilgalyans

    MSTR - Date manipulation

    Thanks - I have set up my time heirarchy Year, Period, Week and Day... The SQL looks like: select a12.PRD_LVL_CHILD PRD_LVL_CHILD, max(a13.PRD_NAME_FULL) PRD_NAME_FULL, a11.SLS_YEAR CALCDY, a11.SLS_PERIOD CALCPR, a11.SLS_WEEK CALCWP, a11.SLS_DAY CALCDW, max(a11.SLS_DATE) CALCUR...
  6. neilgalyans

    MSTR - Date manipulation

    I hope someone can help me. Briefly, my company is new to MSTR, and I am setting up the database BI project. I have looked thru other posts and tried some things to solve my problem, but I am stuck: Our database is set up where each line (say a sales database table) has a Year column, Period...

Part and Inventory Search

Back
Top