Wednesday, January 25, 2017

Aggregate a calculated measure in MDX

There are some situations where we need to calculate aggregations on some calculated measures in MDX. Though it might be possible to define such aggregations in a pure calculated measure, the performance of such queries is significantly slower since each calculation has to be done at each leaf member level and them add them all up to the desired level.

The other much more preferred alternative is to declare a real measure and define its value at leaf scope in MDX definition. Using this approach, the aggregations are automatically calculated at the desired level, and since results of the calculations are cached at all relevant levels, MDX queries are slow only for the first time.

Chris Webb explains this approach in details in this blog:

https://blog.crossjoin.co.uk/2013/05/29/aggregating-the-result-of-an-mdx-calculation-using-scoped-assignments/

Thursday, January 5, 2017

Create a knockout controller for sharepoint visual webpart

Using a knockout controller in sharepoints visual webpart without referencing any of the server object model is necessary for the new development paradigms of Sharepoint.

The blog below explains a coherent way to achieve this:

http://community.rightpoint.com/blogs/viewpoint/archive/2013/07/01/sharepoint-2013-web-parts-and-the-app-model-part-3-the-web-part-quot-client-quot-architecture.aspx

c# httpclient The remote certificate is invalid according to the validation procedure: RemoteCertificateNameMismatch

 If we get this error while trying to get http reponse using HttpClient object, it could mean that certificate validation fails for the remo...