Excel file in Applications folder
-
- Posts: 6
- Joined: Thu Sep 13, 2012 7:45 am
- OLAP Product: TM1
- Version: 10.1.100.24588
- Excel Version: 10 12
Excel file in Applications folder
Is there are any way to show excel blob (TM1BlobCreate), which saved in "}Applications", in Applications folder of Architect? Which of tm1api functions need to be used?
Thanks for reply!
Thanks for reply!
-
- Posts: 32
- Joined: Tue Aug 14, 2012 7:47 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2007
-
- Posts: 6
- Joined: Thu Sep 13, 2012 7:45 am
- OLAP Product: TM1
- Version: 10.1.100.24588
- Excel Version: 10 12
Re: Excel file in Applications folder
using TM1FolderEntries() function - I can get only contents of any folder of }Applications, but I didn't need this.
I need to put blob, which would be visible in Architect
Code: Select all
var serverFolder = TM1ObjectPropertyGet(Pool, Server, TM1ServerFolder());
var count = TM1ObjectListCountGet(Pool, User, serverFolder, TM1FolderEntries());
// listing of files and directory contents below
-
- Posts: 32
- Joined: Tue Aug 14, 2012 7:47 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2007
Re: Excel file in Applications folder
clear now, need to put blob
the first thing you need to get TM1EntryReference followed by URLHandle of entry reference
open the blob, use filestream to read block of bytes and use Blob put to store bytes
finally blob close
the first thing you need to get TM1EntryReference followed by URLHandle of entry reference
open the blob, use filestream to read block of bytes and use Blob put to store bytes
finally blob close
Ricky Marwan
-
- Posts: 6
- Joined: Thu Sep 13, 2012 7:45 am
- OLAP Product: TM1
- Version: 10.1.100.24588
- Excel Version: 10 12
Re: Excel file in Applications folder
You almost right, but:
I create blob using TM1BlobCreate(), I can read & write any data, but I can't see created blob/file using Achitect application.
I create blob using TM1BlobCreate(), I can read & write any data, but I can't see created blob/file using Achitect application.
-
- Posts: 6
- Joined: Thu Sep 13, 2012 7:45 am
- OLAP Product: TM1
- Version: 10.1.100.24588
- Excel Version: 10 12
Re: Excel file in Applications folder
What about TM1FolderEntryAdd function? Anyone used it?
-
- Posts: 6
- Joined: Thu Sep 13, 2012 7:45 am
- OLAP Product: TM1
- Version: 10.1.100.24588
- Excel Version: 10 12
Re: Excel file in Applications folder
I've just debugged tm1a.exe application and found that TM1FolderEntryAdd called after add File/add Reference-menu item click: http://d.pr/i/ewIJ
Does anyone know TM1FolderEntryAdd signature?
Does anyone know TM1FolderEntryAdd signature?
- Mike Cowie
- Site Admin
- Posts: 482
- Joined: Sun May 11, 2008 7:07 pm
- OLAP Product: IBM TM1/PA, SSAS, and more
- Version: Anything thru 11.x
- Excel Version: 2003 - Office 365
- Location: Alabama, USA
- Contact:
Re: Excel file in Applications folder
Hi Vamp:
I don't think the TM1 Application components of the TM1 API are officially documented which, when that happens, usually means that:
Hopefully they will officially document these soon given application folders have been around for ages!
Regards,
Mike
I don't think the TM1 Application components of the TM1 API are officially documented which, when that happens, usually means that:
- They haven't gotten around to documenting them officially yet
- They think there's a chance they'll change the implementation/functions and don't want to publish them right now
Hopefully they will officially document these soon given application folders have been around for ages!
Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC
Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
QueBIT Consulting, LLC
Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
-
- Community Contributor
- Posts: 126
- Joined: Sun Jun 29, 2008 9:33 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- Location: Karlsruhe
Re: Excel file in Applications folder
an approach through the backdoor would be the following: you already determined/created
- the xls file in }Externals folder
- the blob with parameter entry ENTRYNAME/ENTRYTYPE/ENTRYREFERENCE
- the path to it in the }Applications folder
you could insert a new element (folder\blob name) in the }ApplicationEntries dimension and hierarchy with the API.
The drawback is that it requires a server restart to make the xls file accessible in Architect.
- the xls file in }Externals folder
- the blob with parameter entry ENTRYNAME/ENTRYTYPE/ENTRYREFERENCE
- the path to it in the }Applications folder
you could insert a new element (folder\blob name) in the }ApplicationEntries dimension and hierarchy with the API.
The drawback is that it requires a server restart to make the xls file accessible in Architect.
-
- Posts: 6
- Joined: Thu Sep 13, 2012 7:45 am
- OLAP Product: TM1
- Version: 10.1.100.24588
- Excel Version: 10 12
Re: Excel file in Applications folder
now I've successfully created copy of folder-object using TM1ObjectDuplicate (I think that I can duplicate any file entry) , after - register it using TM1ObjectRegister and folder appears in Architect