This author has not written his bio yet.
But we are proud to say that AZConAdmin contributed 46 entries already.
SELECT –DB_ID(‘Live_Staging’) DB_NAME(database_id) ,* –SELECT stats.index_id as id, name, avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats (DB_ID(N’Live_DWH ‘), NULL, NULL, NULL, NULL) AS stats JOIN sys.indexes AS indx ON stats.object_id = indx.object_id AND stats.index_id = indx.index_id AND name IS NOT NULL where database_id =6 –where name = ‘idx_customerCredit_customer_endamount’ –where name = […]
Einstellungen -> Datenschutz, Suche und Dienste -> Browserdaten löschen -> Zu löschende Elemente auswählen -> Zeitbereich bitte auf ‚gesamxte Zeit‘ -> Haken gesetzt bei ‚Cookies und andere Website Daten‘ und ‚Zwischengespeicherte Bilder und Dateien‘ Dann -> Jetzt löschen
SET TEXTSIZE 0; — Create variables for the character string and for the current — position in the string. DECLARE @position INT, @string CHAR(8); — Initialize the current position and the string variables. SET @position = 1; SET @string = ‘New Moon’; WHILE @position <= DATALENGTH(@string) BEGIN SELECT ASCII(SUBSTRING(@string, @position, 1)), CHAR(ASCII(SUBSTRING(@string, @position, 1))) SET […]
select REPLACE(ShipAddr,””,‘”‘), case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.Line1’) else NULL end asLine1, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.Line2’) else NULL end asLine2, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.City’) else NULL end as City, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.Country’) else NULL end asCountry, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.CountrySubDivisionCode’)else NULL end as CountrySubDivisionCode, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.PostalCode’) else NULL endas PostalCode from PY_Invoice
gekoppelt an die Application bei z.B. “Save”. (läuft bei STEG) auch ausführen von externen Xstream Jobs möglich. prolog: EXECUTECOMMAND(‘xstreamCLI /execute “TM1 W Umlagekonfiguration anwenden”‘, 1);
EXECUTECOMMAND(‘xstreamCLI /execute “TM1 W Umlagekonfiguration anwenden”‘, 1); — läuft aktuell bei STEG via TM1.
del “D:\DBV Daten\AZNTransfer\*.txt” xcopy \\Dbm-svs\svs\Import\AZN\Archiv\Kunden_Verlag_%date:~-4%%date:~0,2%%date:~3,2%*.txt “D:\DBV Daten\AZNTransfer” rename “D:\DBV Daten\AZNTransfer\Kunden_Verlag_*.TXT” Kunden.txt Zieldatei Beispiel: Kunden_Verlag_20220706.TXT_20220706_020756.TXT
BatchReportService & Report Service RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE TRUE RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET TRUE
via TM1 Application Log in to Cognos TM1 Application Web. On the toolbar, click the Administer Cognos TM1 Applications button . The IBM Cognos TM1 Applications Configuration page opens In the Server Names section, click Add. The Add Server dialog box opens. Enter the following values: Admin Host – Specify the computer name or IP address of the Admin Host on which the Cognos […]
1. in Tm1.cfg auf 5 umstelllen 2.Tm1 Architect öffnen mit DomainUser 3. Wieder den Integrated Security Mode auf 1 zurückstellen 4. in PerformanceModeler oder Architect dem DomainUser als Admin berechtigen (dieser müsste nun auftauchen) 5. Integrated Security Mode erneut auf 5 stellen
