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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSAS Slowly-Changing Dimensions

Status
Not open for further replies.
pjohns

pjohns

Programmer
Mar 21, 2007
25
Can someone point me to resources describing how to report on historical and current data within an SSAS cube that uses a slowly-changing dimension? I know how to implement the SSAS dimension using the SCD attribute types (scdStartDate, scdEndDate, scdOriginalID, and scdStatus), but am not sure how to use these attributes to report historical and current data from the cube using SSRS.

Thanks.

...Phillip
 
Status
Not open for further replies.

Similar threads

Komal0735
  • Locked
  • Question
how to perform partial cube processing without losing data - SSAS, SSIS
Replies
0
Views
198
Komal0735
Komal0735
Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
172
Benedito Almeida
Benedito Almeida
tcstl1
  • Locked
  • Question
Migrating SSAS to new server
Replies
0
Views
174
tcstl1
tcstl1
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
174
juanvg1972
juanvg1972
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
316
Motlatjo
Motlatjo

Part and Inventory Search

Sponsor

Back
Top