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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
OLAP Time Dimension
Can someone refer me to a source for an good example of a complete time dimension table. What I am looking for is a table that will link with the Invoice_Date field of the fact table. It needs to include prior month, prior qtr, prior year dimensions, etc.- LurkAzusa
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Time Dimension Table
Can someone refer me to a source for an good example of a complete time dimension table. What I am looking for is a table that will link with the Invoice_Date field of the fact table. It needs to include prior month, prior qtr, prior year dimensions, etc. -
Format Measures by Rows or Columns
In Analysis 8.0, how do I format measures for the whole report instead of row by row or column? An example would be Measure: Sales Dollars to be formatted as Currency with 2 decimals, Measure: Sales Qty to be formatted as Long Integer, Measure: Gross Margin to be formatted as Percent. It...- LurkAzusa
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
