I am working on a new project using PowerPivot. I have five powerpivot tables and all work and refresh. Windows7.
I get a #N/A error on this:
=CUBESET("PowerPivot Data","[HSList].[HSDescription].children","test",0,"[HSList].[HSDescription]")
But NOT on this:
=CUBESET("PowerPivot Data","[vw_TVM1].[DealName].children","Deals",0,"[vw_TVM1].[DealName]")
The error is pointing to a small table with only two rows. The vw_TVM1 table has 698 rows.
Any ideas why I get this error and what to do?
I get a #N/A error on this:
=CUBESET("PowerPivot Data","[HSList].[HSDescription].children","test",0,"[HSList].[HSDescription]")
But NOT on this:
=CUBESET("PowerPivot Data","[vw_TVM1].[DealName].children","Deals",0,"[vw_TVM1].[DealName]")
The error is pointing to a small table with only two rows. The vw_TVM1 table has 698 rows.
Any ideas why I get this error and what to do?