locked
Please contact the Author of this report RRS feed

  • Question

  • We have a user that has authored a report, and copied that report changed some parameters and saved it as a buch of other reports under her myviews.  Now when she tries to run the report she gets "There is a problem with the "ReportName" page and it cannot be loaded.  Please contact the author of this page to correct this problem, or choose another page." Warning dialog.  

    I'm sure this is probably a common issue, how can we change it so it believes that she is the author of the report so we can get the wizard to fix the report?  I'm assuming that there was a dimension or something in the report that has changed, but we are unable to get the wizard to fix that because of the error above?

    Thanks
    Tuesday, January 22, 2008 4:08 PM

Answers

  • Hello,

     

    This message usually appears when the view breaks via something in the cube structure being changed or if the view is corrupt.  If the myviews are stored on the users workstation they would be located in the user's profile directory at \Application Data\ProClarity\Client in a file called MyFavorites.bin.  If the views are located here you can rename the file to .bbk, open with professional, and repair the MDX.  If the myviews are stored on the PAS server you'll need to dig through the database to find them.  You can of course rebuild the views and that may be the most time effective approach.

     

    The 'myviews' views themselves are located in the bookelements table of the PAS database with the view metadata being located in the [XMLData] column.  You can copy/paste this to an XML editor/notepad, correct the MDX, and re-paste it back to the correct location in the table.  You can also write a SQL script to retrieve the data for all views in that user's 'my views' by getting the GUID for the book and retrieving all views with that associated GUID(key).

     

    Hope this helps,

     

    Sean

    Wednesday, January 23, 2008 3:07 PM

All replies

  • Hello,

     

    This message usually appears when the view breaks via something in the cube structure being changed or if the view is corrupt.  If the myviews are stored on the users workstation they would be located in the user's profile directory at \Application Data\ProClarity\Client in a file called MyFavorites.bin.  If the views are located here you can rename the file to .bbk, open with professional, and repair the MDX.  If the myviews are stored on the PAS server you'll need to dig through the database to find them.  You can of course rebuild the views and that may be the most time effective approach.

     

    The 'myviews' views themselves are located in the bookelements table of the PAS database with the view metadata being located in the [XMLData] column.  You can copy/paste this to an XML editor/notepad, correct the MDX, and re-paste it back to the correct location in the table.  You can also write a SQL script to retrieve the data for all views in that user's 'my views' by getting the GUID for the book and retrieving all views with that associated GUID(key).

     

    Hope this helps,

     

    Sean

    Wednesday, January 23, 2008 3:07 PM
  • That helps, at least I can grab there mdx query and then fix it up and save it into a briefing book for the user then we can remove the old ones..

    thanks much!


    Thursday, January 24, 2008 2:51 PM
  • Hi,

     

    We have the same problem as in this iinitial question but only for some users, not all, that belongs to the same windows group. This problem occurs when ProClarity objects like calculated measures gets a windows log in account assigned to it like this: [<##<MEMBER!XXXXXXXXX!Percentage of total Main >##>]

     

    The XXXXXXXXX is the windows account, but without the domain name before.

     

    The reports in a briefingbook could have been created as views first, then copied to a local briefingbook and published to PAS 6.3(with the latest patches). And it is possible that this chain can continue with a PAS briefingbook being saved locally, added with new  calculated members and republished as a new briefingbook.

     

    Are there any rules that tells when a windows log in gets assigned to a ProClarity object and when not?

     

    Yours Sincerely

    Thomas Ivarsson

     

    Friday, September 5, 2008 7:30 AM
  • From the Platform Developer's Guide, available with the ProClarity SDK, under "Decorated Names":

     

    The decorated names of local items (Page Items or My Items) are wrapped by the opening "[<##<" and closing ">##>]" characters, are composed of three parts, and are delimited by exclamation points: [<##<Type!Username!Caption>##>]. The following examples show a local set and member:

     

    [<##<SET!EAndersen!Western Region WA>##>]

    [<##<MEMBER!EAndersen!Profit Past Three Months>##>]

     

    Please let us know if you have further questions.

    Thursday, September 11, 2008 8:38 PM