i have an oltp db that gets updated with data every week or so that i would like to report from....
should i create a new data warehouse design where data is going to flow from the oltp into data warehouse db and then build SSAS on top of DW?
or should i just use the existing oltp and...
I need help with building an MDX query to fetch date data.....
i am trying to get the last date an employee data was changed
i have 2 dimensions and 1 fact table (star schema)
fact table: fact_employee
dimension: date & employee_info
In fact table, i store a boolean field HasChanged?
1 -...
I am trying to remotely log off from a server. I am using the following code:
Set objSystemSet = GetObject("winmgmts:{impersonationLevel=impersonate,(Shutdown)}!\\" & strcomputer & "\root\cimv2")_
.InstancesOf("Win32_OperatingSystem")
WScript.Echo "Starting to Log-Off"
For Each objSystem...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.