Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

We created some sql tables of consolidated data for WebFocus...


robert fuschetto

Recommended Posts

We created some sql tables of consolidated data for WebFocus. I discovered the powerpivot could millions or rows of data. I am no Powerpivot expert but was quickly able to set it on top of one of the sql tables. So now I can use WF as well as Excel. It comes in handy for numerous things; especially testing WF stuff.

Well the PP does not allow one to removed old items from lists like a traditional pivot does by clicking Retain Items and setting to: None.

This seems to be by design from what I read. There must be some way of getting rid of those values though. Anyone have any ideas

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...