Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2014-03-07 : 02:27:53
|
| Hi All,I have to create a kind of user defined HierarchiesCurrent month weeks --> name os the hierarchy under this it should have the Week name like 2014/03/01 under this it should have the dates of this week like 2014/03/01similerly for next week Week name like 2014/03/02dates of this week like 2014/03/02 to 2014/03/08can some one please tell me how to do this in SSAS?Is there any built in functions to do this.thanks in advance. |
|
|
learntsql
524 Posts |
Posted - 2014-03-10 : 01:22:29
|
| Hi All,Any Idea please?Thanks in advance. |
 |
|
|
sqlsaga
Yak Posting Veteran
93 Posts |
Posted - 2014-03-27 : 12:09:35
|
| I don't think you need to create a hierarchy for this.you can actually do this by writing an MDX query to create a dynamic set and use it. If you can post the structure of Date dimension in the cube, it will possible to write an MDX statement.Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles. |
|
|
|
|
|
|
creating custom Hierarchies