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!
-
Transformation
Hi TJM2 and entaroadun, thanks a lot for your replies. That was really helpful. TJM2, I know what a Year to Date transformation is but I haven't heard of a Year to Date Filter! Could you please elaborate on this? Thanks Thukaram- sntrao
- Post #5
- Forum: MicroStrategy, Inc. solutions
-
Transformation
Hi, I want to create a report that looks like this: Metric 1 ============ 2004 2005 A Data is updated fortnightly (not exactly on the 15th and 30th of every month. updates take place on 13th or 14th or 15th or 16th of every month). Today I want sum(Metric 1) from Jan 1, 2005 to Jan...- sntrao
- Thread
- Replies: 5
- Forum: MicroStrategy, Inc. solutions
-
sql
Hey, thanks. this did solve the problem Thukaram- sntrao
- Post #3
- Forum: MicroStrategy, Inc. solutions
-
sql
hi, i generate the following sql while executing a report: 1 select a14.PAY_PERIOD_YEAR PAY_PERIOD_YEAR, 2 sum(a11.DEALER_CONCESSION_AMOUNT) WJXBFS1 3 from CPC.CPC_PRODUCT_FACTS a11, 4 CPC.CPC_REPS a12, 5 CPC.CPC_BRANCHES a13, 6 CPC.CPC_PAY_PERIODS a14 7 where a11.REP_CODE = a12.REP_CODE and 8...- sntrao
- Thread
- Replies: 2
- Forum: MicroStrategy, Inc. solutions
