April 14, 2016 at 11:06 am
I'm using SSAS 2014 Multidimensional. I have a date dimension table that has dates going to about 01/01/2018. However, when I browse the cube using SSMS or in Visual Studio, I only see dates up to 10/29/1998 in the dimension. Is there a limit on how many rows a dimension can display while browsing?
April 15, 2016 at 2:46 am
imani_technology (4/14/2016)
I'm using SSAS 2014 Multidimensional. I have a date dimension table that has dates going to about 01/01/2018. However, when I browse the cube using SSMS or in Visual Studio, I only see dates up to 10/29/1998 in the dimension. Is there a limit on how many rows a dimension can display while browsing?
Are you browsing this dimension data against a fact? By default *most* cube browsers (including the ones you mention) will issue MDX with a NON EMPTY clause, meaning that you will only get dimension members back that have whatever selected fact is in the query. For example if you have no facts for things in 2018 then this will not be displayed. Either right click the results area (in SSMS/VS) and choose "Show Empty Rows", use the dimension browser in the SSDT designer (to see the entire dimension without the context of facts) or write some MDX without the NON EMPTY clause.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply