Search found 135 matches

by mnasra
Tue Sep 13, 2022 7:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: POW workspace specific Picklist
Replies: 3
Views: 628

Re: POW workspace specific Picklist

THANK YOU Declan.
YES, indeed it was a picklist cube. I did not even look at the control cubes, when I did not see a picklist in the attribute.
Shame on me.
Thanks a million
Micheline
by mnasra
Tue Sep 13, 2022 7:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: POW workspace specific Picklist
Replies: 3
Views: 628

POW workspace specific Picklist

HI All, I dont know POW. I am supporting a customer who had another consultant building their POW. I have a problem. There is a dropdown list on 1 of the measure in POW. But there is no picklist in the cube. So it must be defined somewhere in POW. I cannot find it. Also, I tried putting a picklist o...
by mnasra
Fri Aug 19, 2022 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in ActiveForm with "INSTR" does not work
Replies: 11
Views: 13102

Re: MDX in ActiveForm with "INSTR" does not work

THANK YOU. THANK YOU. THANK YOU.

4 days I have been trying to find a solution until I wrote the right keyword into the forum.
THANK you all.
This Forum is SUPER.
PS: english is my third language.
by mnasra
Wed Aug 17, 2022 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX help with 2 dimensions on rows
Replies: 3
Views: 991

Re: MDX help with 2 dimensions on rows

Ok thank you for getting me out of my misery.
by mnasra
Tue Aug 16, 2022 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX help with 2 dimensions on rows
Replies: 3
Views: 991

MDX help with 2 dimensions on rows

HI Expert, I am not a MDX expert, but I can write some. I have an active report with 2 dimensions on rows (I cannot take them out). Both of them have TM1RPTROW expressions. say DIM1 and DIM2 I am trying to FILTER on a measure of the cube. say: Mes = 'ABC' So I wrote the filter this way on dim1; (lea...
by mnasra
Thu Aug 04, 2022 10:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OdbcOutput Update and Insert
Replies: 2
Views: 721

Re: OdbcOutput Update and Insert

It is a SQL Server table.
And yes, it is exactly what usually we do. I appreciate the answer, because the more techy than me are giving all sorts of SQL commands, and none is working.

Thank you for your help, I will stop looking and do exactly what you said.
by mnasra
Thu Aug 04, 2022 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OdbcOutput Update and Insert
Replies: 2
Views: 721

OdbcOutput Update and Insert

Hi Expert, I know how to write the sql for odbcoutput Insert (if I truncated the table). I know also how to write the Update, if I dont want to truncate the table. My problem, is that the second one (which I want to use, because I dont want to truncate the table) does not do the inserts for new reco...
by mnasra
Thu Jun 30, 2022 8:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: mdx replace value with excel coordinate
Replies: 5
Views: 1667

Re: mdx replace value with excel coordinate

Correction.
I tried

{TM1FILTERBYPATTERN( {TM1DRILLDOWNMEMBER( {TM1SUBSETALL( [Classe] )}, ALL, RECURSIVE )}, ' " &$B$10& " ' ) }

in a different environment (I think excel is newer) it worked.
Lesson learnt.

thanks
Micheline
by mnasra
Thu Jun 30, 2022 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: mdx replace value with excel coordinate
Replies: 5
Views: 1667

mdx replace value with excel coordinate

Hi Expert, I am using an active form. I need to filtrate my first column with a value. I created an MDX to do that and it works perfectly: example: {TM1FILTERBYPATTERN( {TM1DRILLDOWNMEMBER( {TM1SUBSETALL( [Classe] )}, ALL, RECURSIVE )}, '*am*')} This will give me all the classes that contains AM Now...
by mnasra
Thu Sep 16, 2021 11:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CELL STATUS
Replies: 4
Views: 4547

Re: CELL STATUS

That makes sense too.
Thanks Olando
by mnasra
Sat Sep 11, 2021 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CELL STATUS
Replies: 4
Views: 4547

Re: CELL STATUS

Oh wow. Thank you very much Paul for taking the time to answer. I realized yesterday when I saw the number of people who read the message with no answer, it means the solution is not simple. I did solve my problem by creating an alternate hierarchy in my dimension (used in the rows of the report) ca...
by mnasra
Fri Sep 10, 2021 9:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CELL STATUS
Replies: 4
Views: 4547

CELL STATUS

Hi expert, I cant believe I am asking this question: but how do I find the cell status in a rule. I know how to get it on a view : RIGHT click (on cell) - EDIT status. it will answer : editable or not. I know how to do it in a TI process with cellisupdateable. but, I need it in an active form. I nee...
by mnasra
Tue Jul 27, 2021 11:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process in architect weird error
Replies: 4
Views: 3659

Re: TI process in architect weird error

Hi Steve, Now that you are asking me, it was 1 line inside the 'Generated Statement'. So in Architect, IN PROD, I am reading a line that is inside the generated Statement. but when I open the .PRO process using notepad (just to check), this line does not exist, because I had deleted it in dev and I ...
by mnasra
Tue Jul 27, 2021 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process in architect weird error
Replies: 4
Views: 3659

Re: TI process in architect weird error

Thanks Alexander,

I did check everything. The only thing I did not do, is stop the whole admin server or the physical server.
it is just scary that what you see in architect, is not always what is in the file itself.
I will have to be very vigilant.
thank you again.
by mnasra
Mon Jul 26, 2021 10:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process in architect weird error
Replies: 4
Views: 3659

TI process in architect weird error

Hi Experts, I have a TI process that I copied from DEV to Prod (.pro file). IN PROD: I deleted all blb files I stopped the service I Copied the PRO file (replacing the old) I restarted the service The TI process in Architect is still showing the old process. Other than copy-pasting prolog-variables-...
by mnasra
Wed Jul 14, 2021 11:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drillthrough from 1 cube to another
Replies: 2
Views: 3028

Re: Drillthrough from 1 cube to another

Hi All, I finally found a way. I dont know if it is the best way, but it works for me. As I see that many people read but did not answer, here is what I did: In the drill Process, i created the view of the drill-to cube using a subset of the dimension that has a different name. in the prolog, I recr...
by mnasra
Wed Jul 14, 2021 10:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manual Sort Order TI Process
Replies: 4
Views: 5402

Re: Manual Sort Order TI Process

Hi Declanr,

Yes, that definitely will work. Thanks a lot.
I will try it. it is worth it.
thanks
by mnasra
Wed Jul 14, 2021 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drillthrough from 1 cube to another
Replies: 2
Views: 3028

Drillthrough from 1 cube to another

Hi All, I have not done a drillthrough for long time and I dont seem to find my info. I am drilling from 1 cube to another where the dimension names are different. So cube 1 has a dimension called COMPANY (drill from) and Cube 2 has a dimension called GR-Company (drill to) My drillthrough works for ...
by mnasra
Wed Jun 02, 2021 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manual Sort Order TI Process
Replies: 4
Views: 5402

Re: Manual Sort Order TI Process

Thank you Tomok,
I was afraid that would be the answer when I saw how many people read my post and did not answer!
by mnasra
Tue Jun 01, 2021 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manual Sort Order TI Process
Replies: 4
Views: 5402

Manual Sort Order TI Process

Hi Experts, I need to keep the SORT Order of the Chart of Accounts dimension as Manual. But I want all level 0 items to be 'automatically' sorted under level 1 (their immediate rollup) Has anyone written a TI process for that? is there a different solution? thank you PS: I tried to search in the for...