Search found 114 matches

by kenship
Sun Dec 09, 2018 8:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.6 Temporary Subset Unable To Register
Replies: 5
Views: 752

Re: PA 2.0.6 Temporary Subset Unable To Register

Thanks for the reply. I probably won't go as far as you but like I said I either apply view and subset clearing in epilog or name the subset uniquely depending on the situation. Kenneth I would suggest that a far better approach to deleting a temporary view or subset (which is a bit of an oxymoron) ...
by kenship
Sun Dec 09, 2018 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.6 Temporary Subset Unable To Register
Replies: 5
Views: 752

Re: PA 2.0.6 Temporary Subset Unable To Register

Thanks for your reply.

I just want to confirm that I'm not the only one who has this problem.

Ken
by kenship
Fri Dec 07, 2018 8:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.6 Temporary Subset Unable To Register
Replies: 5
Views: 752

PA 2.0.6 Temporary Subset Unable To Register

We just upgraded from 2.0.4 to 2.0.6 and realize many processes that utilize the automatic clearing of temporary view and subset not working for us. It seems like if a process chain is called the clearing won't happen until the end of the process chain. In 2.0.4 it seems to be cleared at the end of ...
by kenship
Wed Sep 26, 2018 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice to Upgrade TM1 10.2 to PA
Replies: 0
Views: 633

Best Practice to Upgrade TM1 10.2 to PA

Hi, I have been testing upgrade from TM1 10.2 -> PA. I have been seeing a few issues. My work flow is very simple: 1. Back up all 10.2 objects (cubes, dimensions, rules, TIs), this server has no persistent feeders. 2. Shut down PA server. 3. Put the 10.2 objects into the directory where the existing...
by kenship
Tue Sep 18, 2018 6:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Loses Input Data From 10.2 to PA 2.0
Replies: 1
Views: 221

Re: Cube Loses Input Data From 10.2 to PA 2.0

I'm posting an update.

I removed cube and cell security rules reloaded cube from backup. The amount that was lost before is now available. It is strange because the missing data is restricted for input using cell security. I didn't expect cell security will affect this but it seems so.

Kenneth
by kenship
Tue Sep 18, 2018 4:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Loses Input Data From 10.2 to PA 2.0
Replies: 1
Views: 221

Cube Loses Input Data From 10.2 to PA 2.0

Hi, I'm testing to upgrade from 10.2 to PA 2.0. For convenience, I copied all related 10.2 objects (cubes, dimensions, rules) and put it into a newly created instance in PA 2.0 then restarted the service. Upon checking cube data I realized a good amount of input data (hard data, not from rule nor TI...
by kenship
Wed Aug 22, 2018 12:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuration Directoy
Replies: 4
Views: 244

Re: Configuration Directoy

Thanks for the reply. What's astonishing for me is how we got there, I mean, pointing to another directory that is created years later. Unfortunately I have no access to Cognos Configuration. Hopefully our back end will take care of this. Thanks for the advice. Kenneth Mind to share what you have be...
by kenship
Tue Aug 21, 2018 8:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuration Directoy
Replies: 4
Views: 244

Re: Configuration Directoy

Mind to share what you have because I did spend an hour to research here and Google and the results are not helpful. The closest I got was: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_locationofthetm1s.cfgfile_n15038e.html This is not someth...
by kenship
Tue Aug 21, 2018 5:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuration Directoy
Replies: 4
Views: 244

Configuration Directoy

Hi all, I'm running 10.2. We have 2 instances on the same server. One called "Budget", and the other one called "BudgetTrain". I have cleaned up the data files in "BudgetTrain" (e:\data\budgettrain\cxmd). Then I realize in the "Budget" instance a long list of messages were found, after analyzing it ...
by kenship
Tue Jun 19, 2018 6:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewRowDimensionSet
Replies: 2
Views: 556

Re: ViewRowDimensionSet

Thank you for telling me I have nothing to worry about.
tomok wrote:
Tue Jun 19, 2018 6:01 pm
kenship wrote:
Tue Jun 19, 2018 5:45 pm
I have never used this and wonder what benefit it brings
None whatsoever if the purpose of the view is to serve as a data source in a TI process. This function is only useful when creating views to be consumed in the cube viewer.
by kenship
Tue Jun 19, 2018 5:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewRowDimensionSet
Replies: 2
Views: 556

ViewRowDimensionSet

Hi,

I was looking at someone's code in creating a subset and view for cube data transfer and realize they use ViewRowDimensionSet.

I have never used this and wonder what benefit it brings. I searched around but found no answer.

Kenneth
by kenship
Mon Jun 18, 2018 1:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Public Subset Alias Turned Off After Dimension Rebuild
Replies: 4
Views: 635

Re: Public Subset Alias Turned Off After Dimension Rebuild

Thanks! I'll include alias while rebuilding the dimension.
by kenship
Fri Jun 15, 2018 6:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Public Subset Alias Turned Off After Dimension Rebuild
Replies: 4
Views: 635

Public Subset Alias Turned Off After Dimension Rebuild

Hi all,

I just found out that after rebuilding a dimension from load file, alias in dynamic subset will be turned off.

Is there any solution to this?

Kenneth
by kenship
Thu Jun 07, 2018 3:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracing cube load after unload
Replies: 6
Views: 478

Re: Tracing cube load after unload

Wim Gielis wrote:
Thu Jun 07, 2018 3:15 pm
No it's the TM1 server message log that was suggested.
Hi Wim,

I checked the server log ("TM1server.log") and I realize one of the cubes I'm checking has feeders, I'll disable that. Thanks!

Kenneth
by kenship
Thu Jun 07, 2018 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracing cube load after unload
Replies: 6
Views: 478

Re: Tracing cube load after unload

I'll start looking at dependency and rules to see if I can pinpoint the source.

Thanks again!
by kenship
Thu Jun 07, 2018 2:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracing cube load after unload
Replies: 6
Views: 478

Re: Tracing cube load after unload

Thanks for the answers.

For the log, does it mean I have to make sure cube logging is on?

For the feeder, I checked and there's no feeder associated.

Kenneth
by kenship
Thu Jun 07, 2018 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracing cube load after unload
Replies: 6
Views: 478

Tracing cube load after unload

Hi, We have a few cubes which we unload manually and have the Demand Load status updated to "Yes" in Cube Properties. Yet some of them are later started and we don't have any idea why. We want to know whether it is started by a user or something else, is there any way that we can find the informatio...
by kenship
Wed May 30, 2018 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter based on element value
Replies: 2
Views: 422

Re: MDX filter based on element value

This is perfect! I didn't know about currentmember.name. Thank you very much! You have a couple of issues here: 1/ [cbm_year] in the filter is something that it doesn't know what to do with - you would need to specify that it is the name from the currentmember you are wanting to use. 2/ Even then yo...
by kenship
Wed May 30, 2018 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter based on element value
Replies: 2
Views: 422

MDX filter based on element value

Trying to perform MDX with filter without success. I have a year dimension ("cbm_year"): From 1996 to 2050 all rolled up to "All Years". The MDX needs to filter out all years before 2012. I thought it should be really simple: {Filter( {TM1FILTERBYLEVEL( TM1DRILLDOWNMEMBER({[cbm_year].[All Years]}, A...
by kenship
Tue May 15, 2018 2:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset with Expand Above
Replies: 3
Views: 435

Re: Dynamic Subset with Expand Above

Thanks for the reply. For now my solution is break the relationship of the "(Net Profit)" by skipping a level in Gross Expenditures and Revenues. In doing so the dynamic subset reads each rollup separately and allow me to insert "(Net Profit)" as a separately item instead of it being related in the ...