Format date in Batch yyyyMMdd

The usual approach to build a timestamp for a log files in a batch is to use standard Windows utilities date and time. However the format of the output depends on locale and it is almost not possible to make the script which runs on any machine. A solution might be to create a small java […]

Find MenuID and RoleID corresponding to ComponentID in Maconomy Portal

Component/Role/Menu SELECT COMPONENTID , ROLEID , MENUID FROM MENUITEM WHERE COMPONENTID LIKE '%::BPM::%' DFME: SELECT DISTINCT COMPONENT.COMPONENTID , COMPONENT.LABEL COMPONENT_LABEL , MENU.NAME MENU_NAME , USERROLE.NAME USERROLE_NAME , FIELDATTRIBUTE.ATTRIBUTEVALUE FROM MENUITEM INNER JOIN COMPONENT ON MENUITEM.COMPONENTID = COMPONENT.COMPONENTID INNER JOIN MENU ON MENUITEM.MENUID = MENU.MENUID INNER JOIN USERROLE ON USERROLE.ROLEID = MENUITEM.ROLEID LEFT JOIN FIELDATTRIBUTE ON […]

How to find running SQL queries – Oracle

Running queries with performance metrics SELECT S.SQL_ID, S.MODULE, S.SQL_TEXT, U.USERNAME, ROUND((S.DISK_READS/DECODE(S.EXECUTIONS,0,1, S.EXECUTIONS)),2) DISK_READS_PER_EXEC, S.DISK_READS, S.BUFFER_GETS, S.PARSE_CALLS, S.SORTS, S.EXECUTIONS, S.ROWS_PROCESSED, 100 – ROUND(100 * S.DISK_READS/GREATEST(S.BUFFER_GETS,1),2) HIT_RATIO, S.FIRST_LOAD_TIME, S.SHARABLE_MEM, S.PERSISTENT_MEM, S.RUNTIME_MEM, S.CPU_TIME, S.ELAPSED_TIME FROM SYS.V_$SQL S, SYS.ALL_USERS U WHERE S.PARSING_USER_ID=U.USER_ID AND UPPER(U.USERNAME) NOT IN ('SYS','SYSTEM') ORDER BY 5 DESC SQL query in pieces SELECT * FROM SYS.V_$SQLTEXT […]

Merging and filters in BO XI 3.1 SP6

Let's define two similar queries for 2004 and 2005. The query for 2004 looks like: The queries are merged by Service: Now we want to filter table based on a measure from one of the queries. Let's define variable v_Filter as =Abs([2004].[Revenue])<100000 With the following report filter, the table will show 3 rows and it is expected. […]

Solution: Cannot launch Java Report Panel, please make sure you have installed a Java virtual machine

Start cmd.exe as Administrator Execute the following command which turns off blocking of outdated ActiveX controls for Internet Explorer reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Ext" /v VersionCheckEnabled /t REG_DWORD /d 0 /f Restart IE PS. To enable blocking again, use command reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Ext" /v VersionCheckEnabled /t REG_DWORD /d 1 /f

XI 3.1 Issue with Excel Data Provider

Problem A Webi document has a query based on Excel (Excel data source). The document can be refreshed in Web Intelligence Rich Client, but it fails in Infoview with WIS 30270 error. The following errors appear in the log: ExtensionFactoryImpl.cpp:201:void __thiscall WICDZExt::ExtensionFactoryImpl::createRemoteExtension(const class WICDZExt::ExtensionDescriptor &,struct WICDZExt::IExtension **): TraceLog message 24650 2014/10/17 09:02:31.474|>>|E| |13916|15036| |||||||||||||||ExtensionFactoryImpl::createRemoteExtension has […]