| |
|
Data Dynamics Analysis Support
Started by pmeinl at 01-27-2010 4:55 AM. Topic has 3 replies.
  
|
|
Sort Posts:
|
|
|
|
 01-27-2010, 4:55 AM
|
pmeinl
Joined on 01-27-2010
Posts 1
|
Support for WCF Data Services?
|
|
|
|
|
Will you support WCF Data Services?
I am right in assuming that currently I would have to convert the query result from a Data Service to a DataSet to be able to use Analysis?
|
|
|
|
|
Report
|
|
|
|
|
01-28-2010, 3:10 PM
|
AashishB
Joined on 12-11-2008
Posts 818
|
Re: Support for WCF Data Services?
|
|
|
|
|
|
Hello,
I am working on this and would reply you soon.
Regards,
Aashish
|
|
|
|
|
Report
|
|
|
|
|
02-02-2010, 10:14 AM
|
Jon Smith - DD
Joined on 02-21-2007
Raleigh, NC
Posts 972
|
|
|
|
pmeinl,
It is possible to bind WCF Data Services to Analysis using the Unbound Data Source. However, the data source must be a flattened hierarchy as Analysis currently cannot follow the navigation properties of the entities. In my sample, I used the SQL Server 2000 pubs sample database to create a data service. I then added a view in the database (on the sql server side of things) and then added this view to my entity data model.
Once this is done, the schema will need to be manually created via the SchemaBuilder API. The attached sample should only need to have the query string modified in the DataServiceHost project's web.config if you already have pubs installed. If you don't have pubs, you can get it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en
Let me know if you have any questions.
-Jon
|
|
|
|
|
Report
|
|
|
|
|
02-02-2010, 10:28 AM
|
Jon Smith - DD
Joined on 02-21-2007
Raleigh, NC
Posts 972
|
Re: Support for WCF Data Services?
|
|
|
|
|
|
Additionally, here is the SQL for the View:
SELECT dbo.titles.title_id, dbo.titles.title, dbo.titles.type, dbo.titles.pub_id, dbo.titles.price, dbo.titles.advance, dbo.titles.royalty, dbo.titles.ytd_sales, dbo.titles.notes,
dbo.titles.pubdate, dbo.authors.au_id, dbo.authors.au_lname, dbo.authors.au_fname
FROM dbo.titles INNER JOIN
dbo.titleauthor ON dbo.titles.title_id = dbo.titleauthor.title_id INNER JOIN
dbo.authors ON dbo.titleauthor.au_id = dbo.authors.au_id
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics A... » Re: Support for WCF Data Services?
|
|
|
|
|