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!
-
Problem with processing Time Dimension
Hi, I have got problem with processing Time Dimension. What I did - customer wanted to extend Time dimension with week. So I created new dimension in already running cube. This dimension was generated into the database, but somehow it updated actual time dimension and disconnected relations in...- Pavel1234
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Sum of column instead of row
Hi, I have got problem described on following picture: In table A there is SUM of Inventory Value = 1083. I spent a lot of time to get this SUM into every row in table B but with no result :-( Anyone help me ??? Its urgent!! Thx- Pavel1234
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Datediff in OLAP
Hi, I have following cube structure: Dimensions: Item(item name), Date(year,month,date) Measure: OnInventoryFrom(first date since was Item on warehouse) What I need is to calculate number of days that is Item in warehouse till now(year,month,date). I need this as a new calcutaled member. I am...- Pavel1234
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
