This author has not written his bio yet.
But we are proud to say that AZConAdmin contributed 76 entries already.
IF EXISTS (SELECT * FROM Xstream.sys.objects WHERE name = ‘qsBaumstrukturenFiBuKoReI’ AND type IN (‘U’) ) DROP TABLE Xstream.Staging.qsBaumstrukturenFiBuKoReI ; SELECT * INTO Xstream.Staging.qsBaumstrukturenFiBuKoReI FROM qsBaumstrukturenFiBuKoReI
net stop xstreamservice net start xstreamservice BatchFile mit diesen beiden Befehlen von Xstream täglich ausführen lassen!
[‘Measures P50 CFSales’:{‘Total L3M closed Periods AY’}]=N:DB(‘P50 CF Sales’, ‘All Periods’, !Clients, !Debitors Top Level Plan, !Products Top Level Plan, ‘L3M closed Persiods AY’); [‘Measures P50 CFSales’:{‘NetSales AY FC Cash’}]=N:DB(‘P50 CF Sales’, DIMNM(‘PeriodsMonth’,(DIMIX(‘PeriodsMonth’, !PeriodsMonth)– DB(‘P50 CF Sales’, !PeriodsMonth, !Clients, !Debitors Top Level Plan, !Products Top Level Plan, ‘TimeLAG Cash Edit’) )), […]
SELECT TOP 1000 T.orderItemId , STUFF(( SELECT ‘,’+(attribute_name+‘: ‘+attribute_value) FROm qsorderoptions where qsorderoptions.orderItemId =T.orderItemId FOR XML PATH(”)) , 1 , 1 , ” ) AS Feld FROM qsorderoptions As T –GROUP BY T.product_id GROUP BY T.orderItemId
SELECT T1.object_id, T1.name AS Spaltenname, T2.name AS Tabelle , T3.name AS SchemaName FROM sys.columns T1 LEFT JOIN sys.tables AS T2 ON T1.object_id = t2.object_id LEFT JOIN sys.schemas AS T3 ON T2.schema_id = T3.schema_id where T1.name like ‘%Grund%’ AND T3.name = ‘PROVIA’
USE MICOS DECLARE @SearchStr nvarchar(100) = ‘fristgerecht’ DECLARE @Results TABLE (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET NOCOUNT ON DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110) SET @TableName = ” SET @SearchStr2 = QUOTENAME(‘%’ + @SearchStr + ‘%’,””) WHILE @TableName IS NOT NULL BEGIN SET @ColumnName = ” SET […]
SELECT * FROMOPENQUERY(dbVerlagProductive, ‘SELECT * FROM DBA.vSVS_ADRN’)
del \\sv-gmg-cpm4\AnalysisCubes\Ziel\*.mdc xcopy /s C:\hapec\Resources\AnalysisCubes\cubeHAPECPlanningGMGInternational-*.mdc \\sv-gmg-cpm4\AnalysisCubes\Ziel ren \\sv-gmg-cpm4\AnalysisCubes\Ziel\cubeHAPECPlanningGMGInternational-*.mdc cubeHAPECPlanningGMGInternational.mdc
Im Windows PowerShell kann man den Pfad des Logfiles eingeben und dann die Einträge Live mitverfolgen: Beispiel: PS C:\Users\hapecadm> cd D:\hapec\Resources\TM1Servers\LHUlm\Log PS D:\hapec\Resources\TM1Servers\LHUlm\Log> get-content -wait -tail 20 tm1server.log
=n Sets the maximum amount of memory (in MB) to be allocated when a user accesses a view. If you do not set the MaximumViewSize parameter, the default maximum view size is 100MB on a 32-bit system, and 500 MB on a 64-bit system. Parameter type: optional, dynamic To specify a maximum amount of memory allocation […]
