Recent content by neilgalyans

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

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

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

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

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

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