Client Workbook Model

S

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.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

B
  • Solved
Can't Find External Links to Remove
Replies
2
Views
800
boconnel
B
S
  • Question
Power Pivot Refresh Error - Could not find installable ISAM.
Replies
0
Views
714
shanemcgillycuddy
S
R
  • Solved
Loop through Power Query Connections adding them as table to new Worksheet
Replies
2
Views
443
Fluff
Fluff
N
  • Question
How to apply a timeline slicer to a pivot table created using a Data Model?
Replies
0
Views
504
NinaE_11
N
E
  • Solved
Rename and Save ODC files using VBA
Replies
1
Views
899
eriel_ramos
E

Forum statistics

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

Share this page

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