Copy exe as text via clipboard to a remote desktop

Sometimes you are not allowed to transfer files between machines but you can transfer text via clipboard. A little hack how to transfer a file using a standard Windows utility certutil. Create a text file encoding the file certutil -encode file.exe file.txt Open and copy text Create a new file on the remote desktop and […]

"Relationship would not be a tree after update so bailing"

Sometimes a connection cannot be promoted by Promotion Management with the error: Resolution Status=Copied, Dependency Status=All the required dependencies are included., Commit Status=Commit attempted and failed., Promotion Status=Failure : Relationship would not be a tree after update so bailing. It may help to promote connection using BiarEngine. This can display a better message explicitly saying […]

Weird issue in Webi

A query is based on eFashion universe and returns two objects: measure [Promotion Cost USD] and dimension [Duration]. The variable [Cost] is defined as =If [Duration]>0 Then [Promotion Cost USD]/[Duration] The following formula in report’s cell returns #MULTIVALUE =Sum([Cost]) If I just replace the variable with the expression, it will return correct value =Sum(If [Duration]>0 […]

Example of an Indexed View in SQL Server

CREATE VIEW C_FINANCEENTRYPV WITH SCHEMABINDING AS SELECT ACCOUNTNUMBER ,ENTRYDATE ,Sum(IsNull(FINANCEENTRY.DEBITBASE,0)) DEBITBASE ,Sum(IsNull(FINANCEENTRY.CREDITBASE,0)) CREDITBASE ,Count_Big(*) CNT FROM dbo.FINANCEENTRY FINANCEENTRY GROUP BY ACCOUNTNUMBER, ENTRYDATE GO CREATE UNIQUE CLUSTERED INDEX C_FINANCEENTRYPV_01 ON C_FINANCEENTRYPV ( ACCOUNTNUMBER, ENTRYDATE ) GO SELECT * FROM C_FINANCEENTRYPV WITH (NOEXPAND)

How to Use Reposcan to Repair CMS and FRS

This post describes the steps to repair CMS database and Filestore using SAP BusinessObjects reposcan.exe. Note that this may delete some items from CMS or Filestore if the dependencies are not found. Make sure that you have made necessary backups before applying reposcan. You can run the tool without repairing option (or with -repair off). This […]