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

    TimeSpan Prob

    thx Daffy but - as far I understand you in the right manner - in this case a have to calculate "shopping Active" before running the cube for only one fixed Date. In this case it might be faster to use ms-query ;-)) Greg
  2. Greg007

    TimeSpan Prob

    Hello I have prob TimeDimensions. Its about customers in a supermarket. ROWDATA CustomerID VisitStartTime VisitEndTime Spending TimeDimension Year, Month, Day, Hour; Minute I know how to calculate Total-Spendings along TimeDimension, no Prob. Question: How can I calculate the number of...
  3. Greg007

    WEEK as TimeDimension in AS

    Hello Based on a timetable for one year with fields like "2004-02-18 18:52:00.000" the TimeDimension Year, Month, Day, Hour work very fine. BUT, I can not switch to YEAR/WEEK as TimeDimension in Analysis Services. Does anyone know why and how to set up WEEKs ? knd rgds Greg
  4. Greg007

    Non-Aggregated Calculation on Fact-Table

    Hello I like to multiply to Fields in a row of a fact table. Working with "Calculated Members" will first aggregate the data within a given group and then multiply the aggregated Fields. Is there any way to calculate first and aggregate later ? thx for support Greg

Part and Inventory Search

Back
Top