Client Workbook Model

scott Hyde

New Member
Joined
Sep 30, 2011
Messages
5
Hi there

I have PP up and running in SP enterprise. Working nicely but would like to split bulky data to thin Client workbooks.

I tried creating ODC file from data workbook from the SP option to create new workbook - but this connection only gives me limited data and only a few COUNT type kpis and NO dax.

Can anyone point me to material that would explain how to set up the client / Server model for workbooks.

thanks!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
ahhh
Actually spoke to soon..followed instructions and still have problem in that pivot functionality in thin workbook very limited and not useful.
Anybody else got this hub-spoke model going?

thanks
 
Upvote 0
The hub/spoke (or thin/core as we call it at Pivotstream) model does NOT allow for measuring authoring in the thin workbooks. We do all of our measure authoring in the core workbooks and then just author reports in the thins.
 
Upvote 0
Thaks Rob - yeah I came to this finding & conclusion about 3am last night - thanks - Im all good - make sense to keep all measures in one Spot.
 
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top