Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Forcing SQL to use certain tables

Forcing SQL to use certain tables

Forcing SQL to use certain tables

I am having an issue in 7.0.2 -- perhaps someone in this group has had this issue before.  I have implemented some aggregate tables into my project but am having trouble forcing the reports to select from the tables.  Mapping is set to automatic so all attributes and metrics can see the new table, I've updated the schema, and I have even manually adjusted the table logical size.  I am in 2 tier so I have forced out caching as a source of my troubles.

Any suggestions?

RE: Forcing SQL to use certain tables

It sounds like you may have simply overlooked some nuance in your report between the base fact table and the aggregate table, especially if there are multiple metrics.  I would attempt troubleshooting by building the smallest report that you would expect to hit the aggregate table, and if it works, build it up one attribute/metric at a time.  When it stops hitting the aggregate table, dig into the attribute/metric that tripped it up.

RE: Forcing SQL to use certain tables

JRO - you're right that there are things missing...one obvious area of concern is that all my base table joins are modeled correctly through corresponding attributes.  So I have been careful to look at the model and analyze relationships, i.e. parent child, etc.  There is simply one pass that is troublesome, because the 5 facts in that pass are modeled no differently than the 25 facts that go against the aggregate.  Its a little frustrating, and requires digging.  We'll figure it out in time, but sometimes when you hit a wall it doesn't hurt to throw it out to the community...

If anyone has any tricks, etc. that have worked in the past please advise.


RE: Forcing SQL to use certain tables

something else to consider...for each of the 5 facts do a search for dependents and see if your aggregate table shows up.  if they don't show up then dig into the fact definition to see if the aggregate tables are mapped.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close