Forum Discussion
What's the recommended way to develop push datasets?
I'm talking about the "rich" kind with multiple tables, measures, relationships.
I ask because that's what I'm working on, and it's slow-going.
I started by noticing that the JSON for these looks basically like SSAS tabular bim files. So I first made a tabular model with the tables/relationships/measures/datatypes/stringformatting I wanted, and tried to copy/paste into a C#-driven push dataset.
So now I'm manually picking through the JSON bits, taking out the ones that won't successfully POST (annotations, for example don't seem to translate from tabular to push datasets).
This process seems wildly inefficient. Is there a better way to develop rich data modelling push datasets?
2 Replies
Hi Anonymous,
What's your data source? I would suggest you code some scripts to get data and to format as JSON. I think almost all the work can run automatically.
Best Regards,
Dale
Hi Dale - thanks for the reply.
My data source is SQL Server.
Can you expand on your "code some scripts" suggestion?
Right now I'm basically following this example, because I couldn't find any others that do the same thing:
If you look though the solution files there, you'll see that this structure requires that I come up with the JSON (that looks like an ssas tabular bim file).
I'm more than open to another development approach that results in this!
