Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  Universal reports work in 98, but not in 99

    Posted Fri December 13, 2024 04:58 AM

    I have a second issue with Universal reports. When I try to create a UR in 99 (dynamic and static), I get this error:

    With 98 the same thing works. Did anyone experience this? What could cause it?



    ------------------------------
    Christian Wagner
    ------------------------------


  • 2.  RE: Universal reports work in 98, but not in 99

    Posted Mon December 16, 2024 08:35 AM

    Christian,

    I was getting this error as well on both Dynamic and Static.  I found in my case it was because I wasn't using a subset in one of my context dimensions and when the report construction areas were exposed there was a '?' in those places.  As soon as I entered an element or subset the error message went away and my report completed.  Still a bug but can be resolved quickly.

    Dean



    ------------------------------
    Dean Watts
    ------------------------------



  • 3.  RE: Universal reports work in 98, but not in 99

    Posted Mon December 16, 2024 11:09 AM

    Hi Dean, I had tried this. There are subsets everywhere. The reason must be something else.



    ------------------------------
    Christian Wagner
    ------------------------------



  • 4.  RE: Universal reports work in 98, but not in 99

    Posted Tue December 17, 2024 09:28 AM

    Hey Christian,

    We have seen this error before, I am guessing it is this APAR: PH59339: PH59339 MDX ERROR WHEN CREATING UNIVERSAL REPORT DUE TO SPECIAL CHARACTER IN ALIAS NAME IN TM1SET. To validate, make sure none of your element or subset names have "special characters".

    Cheers



    ------------------------------
    Ryan Clapp
    ------------------------------



  • 5.  RE: Universal reports work in 98, but not in 99

    Posted Tue December 17, 2024 01:16 PM

    Hi Ryan, I had checked this as well. All subset names are "Default".



    ------------------------------
    Christian Wagner
    ------------------------------



  • 6.  RE: Universal reports work in 98, but not in 99

    Posted Tue December 17, 2024 01:41 PM

    How about that element name with the " ( )" in it?

     

     






  • 7.  RE: Universal reports work in 98, but not in 99

    Posted Tue December 17, 2024 04:17 PM

    Removing it had no effect. The error stays. And it's only in 99, not in 98.



    ------------------------------
    Christian Wagner
    ------------------------------



  • 8.  RE: Universal reports work in 98, but not in 99

    Posted Wed December 25, 2024 05:32 PM

    I figured out, what causes the error. It seems, that Universal Reports can't deal with my custom stylesheet. Switching back to the original stylesheet solved the issue. But now I need to use the old Cognos BI design as a starting point for PAfE reports, which is odd.



    ------------------------------
    Christian Wagner
    ------------------------------