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!

Adding Filter

Status
Not open for further replies.
jonwolds

jonwolds

Programmer
Aug 6, 2002
194
GB
Hi,

I have created a time dimension from my Time_Dim table which stores dates upto the year 2030. I only want to display dates in the dimension which have corresponding data in the fact table.

What is the best way to do this?

Thanks
Jon
 
Sort by date Sort by votes
where Time_Dim.Time=Fact_Table.Time

Dr.Sql
Good Luck.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
192
JP_Quinn
JP_Quinn
scabral1979
  • Locked
  • Question
filtering using strtoset
Replies
0
Views
139
scabral1979
scabral1979
petersJazz
  • Locked
  • Question
MDX Filter or Except
Replies
0
Views
71
petersJazz
petersJazz
RRinTetons
  • Locked
  • Question
Adding a dimension to a vendor supplied cube
Replies
3
Views
34
RRinTetons
RRinTetons
dkillilea
  • Locked
  • Question
Advandced Filter - Labels
Replies
1
Views
24
MDXer
MDXer

Part and Inventory Search

Sponsor

Back
Top