subset loads from changed .sub file

Post Reply
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

subset loads from changed .sub file

Post by EP_explorer »

Is it possible to do such thing.

I have subset which contain some elements
It has its own .sub file. For example

Code: Select all

283,100
284,Subset7
11,20130416070252
274,
18,0
275,
278,0
281,0
270,5
Regions
Region 3
Region 1
Region 2
Region 4
I want to change subset straightway in file and change it (move element Region 3) and save

Code: Select all

283,100
284,Subset7
11,20130416070252
274,
18,0
275,
278,0
281,0
270,5
Regions
Region 1
Region 2
Region 3
Region 4
Alas nothing happens. I see in Architect the same subset as before
And if I change position in Architect it save .sub file with the same view as in case 2.

May be I should do some operations to load subset after I changed .sub file?
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: subset loads from changed .sub file

Post by qml »

EP_explorer wrote:May be I should do some operations to load subset after I changed .sub file?
Yes, restart the TM1 server. TM1 is an in-memory solution and almost no objects will be re-read from disk during an active server session. Why would a server assume that any objects maintained by it could have been changed by an external action? An exception to this behaviour are private subsets and views that are loaded into memory when a user logs on, not when the server starts.

All in all, you want to be changing objects using the front-end tools you have at your disposal, not using hacks like that (unless there is a very good reason to do so).
Kamil Arendt
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: subset loads from changed .sub file

Post by Alan Kirk »

EP_explorer wrote:May be I should do some operations to load subset after I changed .sub file?
You're not the first to have thought of this but the .sub files are only read:
- On startup for public subsets; or
- On logon for private ones.

Consequently the technique would work for a private subset but only when the user logs out and logs back in.

For a public subset you'd be better off using something like an action button on a sheet to run a TI to update the subset.

However it depends on exactly what you're trying to achieve and why you're trying to do it this way. Hacking the .sub files is hardly an intuitive method of maintaining metadata, and is also somewhat risky given that the format of the metadata text files does sometimes change between versions.

Edit: (QML got in before me (fingers are slow this evening) but I agree with what he said and for the same basic reasons, as I've noted.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: subset loads from changed .sub file

Post by qml »

Alan Kirk wrote:QML got in before me (fingers are slow this evening)
The only reason I beat you to it is that it's only morning for me, so I'm fresh and have the will to live, operate, and co-operate. 8-)
Kamil Arendt
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: subset loads from changed .sub file

Post by EP_explorer »

Post Reply