Microsoft KB Archive/942559

= Error message when you try to save a model in Planning Business Modeler: &quot;The attempt to save Rule_Name failed. Rule Rule_Name contains raw text (either MDX or SQL)&quot; =

Article ID: 942559

Article Last Modified on 10/12/2007

-

APPLIES TO


 * Microsoft Office PerformancePoint Server 2007, 32 Bit Edition
 * Microsoft Office PerformancePoint Server 2007, 64 Bit Edition

-



SYMPTOMS
Consider the following scenario. In PerformancePoint Planning Business Modeler, you have a business rule in a model. The business rule was created by using native code implementation. Additionally, the status of the business rule is Active. When you try to save the model, you receive an error message that resembles the following:

The attempt to save Rule_Name failed. (Error Code: PerformancePoint _130002060) Save rules failed. Rule Rule_Name contains raw text (either MDX or SQL) and is being saved as active. Rules with row text must be saved as inactive and activated by your DBA



CAUSE
This behavior occurs if the status of the business rule is Active. A business rule that is created by using native code implementation has a larger scope of operations than a business rule that is created by using PerformancePoint Expression Language (PEL). For example, a business rule that is created by using native code implementation can potentially delete data from the underlying fact tables. Therefore, business rules that are created by using native code implementation may have potential security issues. To help avoid these security issues, PerformancePoint Planning Business Modeler requires that you save a business rule that is created by using native code implementation only when the status of this business rule is Inactive. Contact your global administrator to let you execute a business rule that is created by using native code implementation.



STATUS
This behavior is by design.



WORKAROUND
To work around this behavior, set the status of the business rule to Inactive. Then, save the model.

This workaround assumes that you created a business rule by using native code implementation in PerformancePoint Planning Business Modeler. Additionally, this workaround assumes that the status of the business rule is Active. To work around this behavior, follow these steps:
 * 1) On the Business Rules tab in PerformancePoint Planning Business Modeler, click the business rule.
 * 2) In the Status column, click Inactive in the list.
 * 3) Perform one of the following operations to save the changes:
 * 4) * On the File menu, click Save this Model.
 * 5) * On the Actions menu, click Reprocess Model Data.



How to let a user create a business rule by using native code implementation
Note You must contact the global administrator to perform the following steps.
 * 1) Start a Web browser.
 * 2) In the Address box, type http:// :46788/, and then press ENTER to open the PerformancePoint Planning Administration Console.
 * 3) In the Planning Administration Console, click Connection.
 * 4) On the Connection page, type http:// :46787/ in the Location box, and then click Connect.
 * 5) Click Applications.
 * 6) On the Applications page, click the application in which you want to create the business rule by using native code implementation, and then click Edit.
 * 7) On the Edit Application page, click to select the Enable native SQL/MDX rules check box, and then click OK.

Now, the user can create a business rule by using native code implementation.

How to let a user execute a business rule that is created by using native code implementation
Note You must contact the global administrator to perform the following steps.  Start SQL Server Management Studio. In the Connect to Server dialog box, type the name of the instance of Microsoft SQL Server in the Server name box, and then click Connect. Click New Query.  In the new query window, run the following Transact-SQL statements. USE AppDB_Name GO

UPDATE dbo.RuleSetsOrRules SET IsActivated = 1 WHERE RuleSetOrRuleName = 'Rule_Name' GO Note  represents the name of the application database. represents the name of the business rule.  Start PerformancePoint Planning Business Modeler. On the File menu, click Connect.</li> In the Connect dialog box, type http:// :46787/ under Select a server, and then click Connect.</li> In the Select an application list, click the application to which the business rule belongs.</li> Under Select a model site, click the model site that contains the business rule, and then click OK.</li> In Planning Business Modeler, click Deploy Model Site on the File menu.</li></ol>

Now, the user can execute a business rule that is created by using native code implementation.

Keywords: kbtshoot kbprb kbexpertiseadvanced KB942559

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.