Tableau adjust tile width to max
Resize sheet to fit screen
This option is available at dashboard
select required tile at dashboard
go to drop down (more options)
Fit–> Fit width
find better solutions for analytics world
Tableau adjust tile width to max
Resize sheet to fit screen
This option is available at dashboard
select required tile at dashboard
go to drop down (more options)
Fit–> Fit width
Lets assume your temp table is #t :
use tempdb
exec sp_spaceused '#t'
Same code can be used to identify space used by table as well
exec sp_spaceused 'schema.tablename'
I used below query to get cognos user list and associated groups. I got this query for cognos version 10.2.2
If query doesn’t provide any data, change classid and mapdlocaleid values and try.
SELECT v_group.name AS group_name,
v_user.ldap_id AS user_name
, CLASSID
, MAPDLOCALEID
FROM dbo.cmreford1 AS v_group_user
JOIN (SELECT cmid user_id,
UPPER (NAME) ldap_id
FROM dbo.cmobjprops33) v_user
ON v_group_user.refcmid = v_user.user_id
JOIN (SELECT cmobjnames.cmid cmid,
UPPER(cmobjnames.NAME) name
, cmobjects.classid
, cmobjnames.mapdlocaleid
FROM dbo.cmobjects, dbo.cmobjnames
WHERE
cmobjects.classid IN (26, 54)
AND cmobjnames.mapdlocaleid = 92
AND
cmobjects.cmid = cmobjnames.cmid) v_group
ON v_group.cmid = v_group_user.cmid
order by 1,2
————————————————————————————————————————–
SELECT v_group.name AS group_name,
v_user.ldap_id AS user_name
FROM dbo.cmreford1 AS v_group_user
JOIN (SELECT cmid user_id,
UPPER (NAME) ldap_id
FROM dbo.cmobjprops33) v_user
ON v_group_user.refcmid = v_user.user_id
JOIN (SELECT cmobjnames.cmid cmid,
UPPER(cmobjnames.NAME) name
FROM dbo.cmobjects, dbo.cmobjnames
WHERE cmobjects.classid IN (26, 54)
AND cmobjnames.mapdlocaleid = 96
AND cmobjects.cmid = cmobjnames.cmid) v_group
ON v_group.cmid = v_group_user.cmid
order by 1,2
when trying to access python from command line- we might get an error when we use – ‘python’. Use ‘py’ instead of ‘python’
C:\Users\tekjedi>python
‘python’ is not recognized as an internal or external command,
operable program or batch file.
C:\Users\tekjedi>python
Python 3.1(v……] on win32
if you are still getting error then check “environment variables”. You need to add python installed folder path at environment variables.
if your python install path is : C:\Programs\Python\Python37-32 then go to control panel, systems–> Advanced system settings –> Advanced tab –> Environment variables –> System Variables –> Path edit –> at variable name enter your python installation path with “;” i.e. “;C:\Programs\Python\Python37-32;” . hit ok.
Key words for search:
python-is-not-recognized-as-an-internal-or-external-command
In command prompt entre systeminfo
‘System boot time’ will tell you the last boot time of the server.