Page 1 of 1

TM1 .NET API VIEW unable to get DataTable

Posted: Wed Aug 04, 2010 7:30 pm
by markustTM1
Hi,
I had my first go at the .NEt API and all appeared to be going very well! It was from a Winforms App (.net 3.5) but TM1 API is proably older.
I was able to locate my Private View! However when I query the IsPrivate property it returns false. When I query IsSystemxxxxx (forget the actual name but is it a system object) it returns false.

So now I'm ready to get the DataTable from the TM1View and the api throws an exception which reads somethin like the client is not an Admin for this object (Argh).
Now I created the view and I'm able to see the data in the TM1 gui and Excel 2007.


Why do I need to be an Admin to read my view? The client is not going to let me be an admin on their system (fair enough)..
Does this error mean I need to be an admin or is admin a group I should be a member of?
Why does it matter what technology I use? it is the same login from the same node.

thanks
mark

Re: TM1 .NET API VIEW unable to get DataTable

Posted: Thu Aug 05, 2010 9:02 am
by markustTM1
I have managed to solve the problem myself, it was just a crappy error message.

I had the lowest level of access; they boosted me to a reporting user level (they can create in-memory cubes) and it all works.
I guess accessing the DataTable requires it to create a temporary cube. Now that I can do that it all works just fine.

m