TOOLS Here is a list of very handy software/utilities/websites making my life much easier. Notepad++ – source code editor which supports multiple languages. You can also can find TM1 add-on for Turbo Integrator processes and Rules (syntax highlighting) TeraCopy – faster and more reliable way to copy files, also it has some additional options: pause,Continue reading “HANDY APPS / SOFTWARE (WINDOWS)”
Author Archives: Vlad Didenko
COGNOS ERRORS
E_MISSING_REQUIRED_ELEMENT– Used when processing a well-formed XML document that is missing a mandatory element. – The ” XML document does not contain the required element ”. E_TRUSTED_REQUEST_REQUIRED– Used when trusted request is required and the request is not trusted request – Trusted request is required. E_MULTIPLE_REQUESTS_FOUND– Used when multiple requests are found in an authenticationContinue reading “COGNOS ERRORS”
TM1 GET WEEK DAY NAME
dn = dim_target; ## week days sWeekdays = ‘SunMonTueWedThuFriSat’; ## week day: 0 = Sunday, 1 = Monday, …, 6 = Saturday nWeekday = MOD( DayNo( TODAY ) + 21915, 7); ## day name lookup sDayName = Subst(sWeekdays,nWeekday*3+1,3);
IBM COGNOS BI SERVER ORDER TO RESTART (DISTRIBUTED ENVIRONMENT)
Restarting the content store database server is not required but is required to be up and running in order for the content manager to connect to it. First, stop the servers in the following order: Gateway (if not a pure gateway server and has a dispatcher installed) Dispatchers (includes Planning Application and Job Servers) SecondaryContinue reading “IBM COGNOS BI SERVER ORDER TO RESTART (DISTRIBUTED ENVIRONMENT)”
COGNOS BI REFRESH TM1 DIMENSION CACHE
Cognos BI in DQM mode caches all the TM1 cube metadata. But sometimes you need to be able to tell Cognos that I got new elements (common example you run import process which added new dimension elements). I tried to set “Use Local Cache” set to “No”, but it didn’t help. The problem was solvedContinue reading “COGNOS BI REFRESH TM1 DIMENSION CACHE”
IBM COGNOS INTEGRATEDSECURITYMODE 5
IntegratedSecurityMode Here I would like to explain some moments of managing security with IntegratedSecurityMode=5. When you configure Cognos TM1 to use IntegratedSecurityMode = 5, in Security -> Clients/Groups you can import clients and groups from Cognos BI security. The only way to add TM1 native security group is to use TI process function: AddGroup(GroupName); YouContinue reading “IBM COGNOS INTEGRATEDSECURITYMODE 5”
KILL WINDOWS STOPPING / RESTARTING SERVICE
open cmd as administrator find service PID running the next command: sc queryex servicename sc queryex “IBM Cognos” kill the process: taskkill /f /pid PID
CMD USEFUL COMMANDS
Computer full name ECHO %COMPUTERNAME%.%USERDNSDOMAIN% Computer/User domain ECHO %USERDNSDOMAIN% List domain group members NET GROUP “domain_group_name_here” /DOMAIN Display detailed configuration information about a computer and its operating system, for example, I often look at System Manufacturer: VMware, Inc. to check if I’m working on Virtual Machine or not. SYSTEMINFO Remove / delete Windows service fromContinue reading “CMD USEFUL COMMANDS”
TM1 MDX: GET ALL THE ASCENDANTS OF SUBSET ELEMENTS
TM1 supports a standard MDX function ASCENDANTS which returns all the parent elements (up to the dimension root). Let’s say you have a dimension like: — World —- Europe —— UK —— France ——– Paris —- North America —— USA —— Canada ——– Toronto —- South America —— Brazil You want to select {Toronto, Paris}Continue reading “TM1 MDX: GET ALL THE ASCENDANTS OF SUBSET ELEMENTS”
VBA LAST ROW / COLUMN WITH DATA
iLastRow = Worksheets(“Sheet1″).Cells(Rows.Count, iColumnToSearchIn).End(xlUp).Row iLastCol = Worksheets(“Sheet1″).Cells(iRowToSearchIn, Columns.Count).End(xlToLeft).Column
Cognos/TM1 