Search found 147 matches

by kenship
Thu Oct 08, 2020 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI not writing string value to consolidated element
Replies: 7
Views: 318

Re: TI not writing string value to consolidated element

Looks like it's the ViewExtractSkipCalcsSet that needs to be inserted.

Thanks very much!
ascheevel wrote:
Thu Oct 08, 2020 6:16 pm
Can you add the below items to your prolog below the other ViewExtract... declarations and re-test?

Code: Select all

ViewExtractSkipCalcsSet('tDemo', 'tView', 0);
ViewExtractSkipRuleValuesSet('tDemo', 'tView', 0);
by kenship
Thu Oct 08, 2020 6:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI not writing string value to consolidated element
Replies: 7
Views: 318

Re: TI not writing string value to consolidated element

Hi all, For simplicity, I created a very small cube to show what I'm trying to accomplish. The cube includes: DimA - (A-TOTAL)->A1, A2 DimB- (B-TOTAL)->B1, B2 Dim_m- $, Description What I'm trying to do is to put string into "Description" for consolidated elements (A-TOTAL), (B-TOTAL) when $ has val...
by kenship
Thu Oct 08, 2020 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI not writing string value to consolidated element
Replies: 7
Views: 318

Re: TI not writing string value to consolidated element

Make sure your TI source view isn't skipping consolidations: ViewExtractSkipCalcsSet? Thanks for the reply. I checked the view and it does include the consolidated elements. I've been testing by changing the CellPutS to special consolidated elements instead of variables and it worked. But I need th...
by kenship
Thu Oct 08, 2020 3:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI not writing string value to consolidated element
Replies: 7
Views: 318

TI not writing string value to consolidated element

Hi all, I have trouble writing to consolidated element of a cube. Here's some details of how I setup the TI process: Data Source: Cube View - Target cube Variables: Based on Target cube dimensions, Variable Type all "String", Contents all "Other" Prolog: 1. Setup Target view and Target subset in Tar...
by kenship
Fri Jul 17, 2020 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DB formula not working when copying rule
Replies: 13
Views: 3523

Re: DB formula not working when copying rule

Glad it helped. At least I'm not the only one. Ken Today I encountered this 'not calculating' issue as awell While I created a new cube in explorer and tried to use DB to mirror the source cube to the targeted cube. I copied and modified the rules from consultant (thank you) and the cube view are al...
by kenship
Wed May 06, 2020 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI load record with unique count for duplicate
Replies: 5
Views: 817

Re: TI load record with unique count for duplicate

Correct. But CellIncrementN is definitely more convenient.

Thanks!
Wim Gielis wrote:
Wed May 06, 2020 1:00 pm
If you forgot about that function, there is still CellGetN to retrieve the value in the cube, then add the new value of the data source, then CellPutN of the sum of both to the cube (same intersection).
by kenship
Wed May 06, 2020 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI load record with unique count for duplicate
Replies: 5
Views: 817

Re: TI load record with unique count for duplicate

Do you need to keep track of each record individually? (In which case you need to introduce some kind of transactional dimension as per Wim's suggestion). Or is it possible to cummulate the duplicate cube address intersections? (In which case you could just use CellIncrementN not CellPutN) Thanks. ...
by kenship
Tue May 05, 2020 7:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI load record with unique count for duplicate
Replies: 5
Views: 817

TI load record with unique count for duplicate

Hi, I'm loading a file with duplicate records. To load all records I need to identify each row with a unique identifier. To solve this I can create a dimension for record count and create a new element for each line so that no record will be overwritten due to duplication. I'm thinking to use the di...
by kenship
Fri Feb 21, 2020 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 1495

Re: Ruled cell not released for write

Probably. But for simplicity I'd rather not create another process to do the job. Thanks! Try updating attribute with RunProcess, so it commits entirely outside of the processing chain. CubeSaveData must be added after attribute update. - No, it only matters if you want to serialize changes to the d...
by kenship
Thu Feb 20, 2020 9:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 1495

Re: Ruled cell not released for write

I tried implementing the suggested solution.

Just moving the load process to Epilog won't work.

CubeSaveData must be added after attribute update.

Thanks to all.

Kenneth
by kenship
Thu Feb 20, 2020 4:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 1495

Re: Ruled cell not released for write

Got it. In my case I'll probably separate the processes and test. Thanks for your input. Kenneth Actually the way the attribute working is just a "Y" under the attribute "Active" in the "Version" dimension. Well, that's not exactly how it works because just setting some attribute on an element is no...
by kenship
Thu Feb 20, 2020 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 1495

Re: Ruled cell not released for write

Thanks for the reply. Actually the way the attribute working is just a "Y" under the attribute "Active" in the "Version" dimension. If my situation is the same as yours then can we say that update due to attribute only "really" happens when the process series is completely finished? Kenneth If this ...
by kenship
Thu Feb 20, 2020 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 1495

Ruled cell not released for write

Hi, I have the following: 1. Cube has rule calculation for only "Active Version" 2. Active Version is attribute in Version dimension 3. Cube subject to Year End Process ("YEpro") 4. YEpro calls for 2 processes: a. "Export" and b. "Import" 5. Export includes rule calculated data 6. Between Export and...
by kenship
Mon Dec 16, 2019 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 1830

Re: AsciiOutput element order different from subset

Update:

Instead of extracting data to a file a decision was made to present data as a view for user. I ended up removing all the codes related to data extraction and data source specification.

Thanks to all.

Kenneth
by kenship
Fri Dec 13, 2019 10:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 1830

Re: AsciiOutput element order different from subset

Thank you! Will try.
ascheevel wrote:
Fri Dec 13, 2019 9:02 pm
For your test cube, your MDX should look something like the below. I'll try to take a look at your other posted code this weekend.

Code: Select all

ViewCreateByMDX('Cube', 'View',
	'select {[Dim1].[1]} on 0,
	{[DimA].[A]} on 1 from [Cube]'
	);
by kenship
Fri Dec 13, 2019 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 1830

Re: AsciiOutput element order different from subset

Hi, I was only testing with a test cube with test dimensions, it was like: ###### ViewCreateByMDX ( 'Cube', 'View', ' { [ Dim1 ] . [1] } , { [ DimA ] . [A] }' ); ###### Below is the MDX expression for the dimensions subject to the view that I wanna export. ############################## vIndexDim = ...
by kenship
Fri Dec 13, 2019 8:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 1830

Re: AsciiOutput element order different from subset

Thanks and I'm actually on PA 2.0.7. I'm trying to research to use ViewCreateByMDX but the statements couldn't figure out the syntax yet for a MDX view. In the mean time I'll probably having a TI for the user that they can name the view and access it then take a snap shot. Thanks! Kenship, is your u...
by kenship
Fri Dec 13, 2019 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 1830

Re: AsciiOutput element order different from subset

Thanks Steve. I tried following your instructions and added a SubsetMDXSet function to remove the MDX. It converts the subset to be static but the export still lists the elements using index order. Basically in my Prolog I created the temp. view and subset then used a WHILE loop for all the dimensio...
by kenship
Fri Dec 13, 2019 4:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 1830

Re: AsciiOutput element order different from subset

An update: now I found this thread: https://www.tm1forum.com/viewtopic.php?t=10604 .

I noticed Tom saying to "do your own walk through the subsets in the Prolog tab using CellGetN and ASCIIOutputs inside WHILE loops".

I wonder what it means.
by kenship
Fri Dec 13, 2019 4:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 1830

AsciiOutput element order different from subset

Hi, I'm trying to get TI to extract data based on a subset that is sorted according to project value based on criteria chosen by a user. I used MDX to sort the project dimension based on the selected criteria and is working. However, when using AsciiOutput I noticed data is sorted based on dimension...