Hi All,
I am facing following error ((TR1901) PDS-PPE-0059 PowerPlay Data Server could not find a record (Level))at the final stage of the cube build process while building the incremental cube. I have tried the options like include categories always.. But it didn't work. After detail analysis I identified that the problem is with the time dimension with alternate drill path. Removing that alternate drill path is resolving that issue. Could you please help me in solving this.
More Info:
Intial build-Success
First Increment-Success
Second Increment-Failed.
Please let me kow if any further information is required.
Thanks,
MC
These should help:
http://www-01.ibm.com/support/docview.wss?uid=swg21348381
http://publib.boulder.ibm.com/infocenter/c7bi/v7r5m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.pp_sbs_trns.7.5.0.doc%2Fpp_sbs_trns_id14010AlternateDrill-DownPathsinTimeDimens.html
But honestly, I would suggest avoiding alt drill paths in the time dimension.
Thanks Grim..
I thought the problem is with the alternate hierarchy but the problem is with the 'Fiscal year' which is starting from 20070701. With regular calendar this is working fine..
Any thoughts?
Thanks..
The problem is with 'prior YTD' but don't know why this is causing problem.. :( removing this its working fine.
I had a problem with a date alternate drill path that I was able to resolve with help from Rob. Not sure if your situation is comparable or not, but thought I'd point you to this thread in case ....
http://www.cognoise.com/community/index.php/topic,18777.0.html
dumb question but do you have data for prior ytd?
Quote from: Arsenal on 11 Apr 2012 02:48:00 PM
dumb question but do you have data for prior ytd?
Hi Arsenal,
There is no data for prior YTD but if that is the case it should throw that error from the 1st increment itself but I am getting this error for second increment.
Thanks
does the log file outputted by Transformer have any further information on the error?
Quote from: Arsenal on 16 Apr 2012 11:29:45 AM
does the log file outputted by Transformer have any further information on the error?
Here is the detailed error
Mon 16 Apr 2012 21:16:21 2 00000000 (TR1102) Transformer detected a model error at line 4 in file /cognosdata/tr10/models/Abc.mdl. (TR1901) PDS-PPE-0059 PowerPlay Data Server could not find a record (Level). in /cognosdata/tr10/cubes/Abc.mdc. [->OK]
Quote from: mrcool on 16 Apr 2012 12:25:31 AM
Hi Arsenal,
There is no data for prior YTD but if that is the case it should throw that error from the 1st increment itself but I am getting this error for second increment.
Thanks
Does the below help
http://www-01.ibm.com/support/docview.wss?uid=swg21348349
Quote from: Arsenal on 17 Apr 2012 11:17:52 AM
Does the below help
http://www-01.ibm.com/support/docview.wss?uid=swg21348349
tried this already but didn't help.. :( Thinking of raising this issue with IBM.
Thank you so much for ur support.
I have raised a PMR with IBM and IBM agreed that it is a defect with cognis 10.1.1 . I will update the status once I hear something from them.
Cheers,
MC