如何使用EnteredDate Column按季度和年度浏览SSAS记录 [英] How to browse the record from SSAS on the basis of quarterly and yearly using EnteredDate Column

问题描述

在我的项目中要求是这样的。



数据库名称 - NewData TableName - 政策



PolicyAID PolicyNo。 ClaimNo EnteredDate

---------------------------------------- -----

1 MNS123 138317 12/02/2013

2 MNS123 138318 13/02/2013

3 MNS456 138319 14 / 02/2014

4 MNS789 138320 15/04/2014



这里一个PolicyNo可以包含1个以上的索赔号。我希望通过使用EnteredDate列以这种方式显示数据。



1.每季度的索赔数量

2.索赔数量按年份



如果记录是这样的SSAS浏览器那么我想在我的asp.net项目中用拖动和删除过滤器功能，如数据透视表，也希望在图表中显示。

In my project requirement is some thing like this.

Database Name - NewData TableName - Policy

PolicyAID PolicyNo. ClaimNo EnteredDate
---------------------------------------------
1 MNS123 138317 12/02/2013
2 MNS123 138318 13/02/2013
3 MNS456 138319 14/02/2014
4 MNS789 138320 15/04/2014

Here one PolicyNo can contain more than 1 claim no. with different or same date.I want to show data by this way by using EnteredDate column.

1. No. of Claims per quarter
2. No. of Claims By year

If the record comes in SSAS browser like that then I want to show this record in my asp.net project with drag and drop filter functionality like pivot table and also want to show in chart.

推荐答案

这篇关于如何使用EnteredDate Column按季度和年度浏览SSAS记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！