开发者

PowerPivot Multiple OData Services Related

I'm playing around with OData with PowerPivot and I would like to know can I relate multiple OData services together?

I don't want to have one huge OData service as I want to roll this out for all of our internal systems. I think one service would get messy.

Something like; http://hosting/Sales.svc开发者_运维百科 http://hosting/Clients.svc http://hosting/Finance.svc

With some relationships mapped within.

Anyone know how I can do this?

Thanks, Mike Mengell


I've worked it out.

In the PowerPivot window you have a design tab. Select create relationship and you can select the enity which can be from any service, in my case it's 2 OData services. Then you select the field for the relationship.

At the moment there doesn't seem to be any automatic relationship creation. Which for me is probably a blocker on using this for my business.

But the process is painless if you understand about the relationships.

I'll write a blog post about this soon and post it here.


Easy; create three services with different Contexts / models.

--larsw

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜