Hi All,
I get the error "An invalid argument was encountered" on an active sheet when I hit action button "Rebuild Sheet".
I have unhidden the entire sheet to see if there is a "*KEY_ERR" or any others.
This active sheet updates two cubes. There is a drop down box (with both cube names) and selection of one triggers the values on the sheet to reflect the values of the selected cube. When the cube opens or when values are entered, nothing errors.
Errors only on hitting refresh. Any ideas?
I am on version 9.5.2, 2008 server, excel 2010.
Thanks,
Luther.
An invalid argument was encountered
-
LutherPaul
- Posts: 80
- Joined: Tue Jun 04, 2013 3:35 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: An invalid argument was encountered
Have you put a statement inside the TM1RPTVIEW formula to point it towards the right cube?
Declan Rodger
-
LutherPaul
- Posts: 80
- Joined: Tue Jun 04, 2013 3:35 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: An invalid argument was encountered
Thanks Declan.
When I try to switch the name in the "TM1RPTVIEW" function, the report gets into non responding mode and does not return even after 5 min. Any further help?
Like I said, rest all works fine. when I switch the cube name from dropdown, the values save / change accordingly. Only when I hit refresh when the cursor is on a data element, I get the error.
Thanks,
Luther.
When I try to switch the name in the "TM1RPTVIEW" function, the report gets into non responding mode and does not return even after 5 min. Any further help?
Like I said, rest all works fine. when I switch the cube name from dropdown, the values save / change accordingly. Only when I hit refresh when the cursor is on a data element, I get the error.
Thanks,
Luther.