{"action":"created","issue":{"url":"https://api.github.com/repos/otykier/TabularEditor/issues/52","repository_url":"https://api.github.com/repos/otykier/TabularEditor","labels_url":"https://api.github.com/repos/otykier/TabularEditor/issues/52/labels{/name}","comments_url":"https://api.github.com/repos/otykier/TabularEditor/issues/52/comments","events_url":"https://api.github.com/repos/otykier/TabularEditor/issues/52/events","html_url":"https://github.com/otykier/TabularEditor/issues/52","id":225016024,"number":52,"title":"Help with deployment Script","user":{"login":"fmms","id":908734,"avatar_url":"https://avatars3.githubusercontent.com/u/908734?v=3","gravatar_id":"","url":"https://api.github.com/users/fmms","html_url":"https://github.com/fmms","followers_url":"https://api.github.com/users/fmms/followers","following_url":"https://api.github.com/users/fmms/following{/other_user}","gists_url":"https://api.github.com/users/fmms/gists{/gist_id}","starred_url":"https://api.github.com/users/fmms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fmms/subscriptions","organizations_url":"https://api.github.com/users/fmms/orgs","repos_url":"https://api.github.com/users/fmms/repos","events_url":"https://api.github.com/users/fmms/events{/privacy}","received_events_url":"https://api.github.com/users/fmms/received_events","type":"User","site_admin":false},"labels":[{"id":481492747,"url":"https://api.github.com/repos/otykier/TabularEditor/labels/help%20wanted","name":"help wanted","color":"128A0C","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-04-28T08:41:41Z","updated_at":"2017-04-28T09:54:08Z","closed_at":null,"body":"Hi,\r\n\r\nthis is not an issue but just asking for some advice -- adding some links so this is helpful for others in the future.  I am currently looking into automatic deployment (https://github.com/otykier/TabularEditor/wiki/Advanced-features#command-line-deployment)  and have some questions about the script (https://github.com/otykier/TabularEditor/wiki/Advanced-Scripting).\r\n\r\n* I'd like to change the DataSource Connection String during deployment. `Model.DataSources[\"DWH\"]` does not seem to have any usefull attributes. How can the connection String be set?\r\n* I'd like to set `Model.Description` with the current time and user name. Is this possible?\r\n* Is there any way to set the Database Description? I can see this in SSMS. However, to my understanding in tabular I am scoped to the model...?\r\n* Is my understanding correct, that processing the cube is out of scope of tabular editor? (cf #22)\r\n\r\nThanks for your help."},"comment":{"url":"https://api.github.com/repos/otykier/TabularEditor/issues/comments/297958113","html_url":"https://github.com/otykier/TabularEditor/issues/52#issuecomment-297958113","issue_url":"https://api.github.com/repos/otykier/TabularEditor/issues/52","id":297958113,"user":{"login":"otykier","id":8976200,"avatar_url":"https://avatars0.githubusercontent.com/u/8976200?v=3","gravatar_id":"","url":"https://api.github.com/users/otykier","html_url":"https://github.com/otykier","followers_url":"https://api.github.com/users/otykier/followers","following_url":"https://api.github.com/users/otykier/following{/other_user}","gists_url":"https://api.github.com/users/otykier/gists{/gist_id}","starred_url":"https://api.github.com/users/otykier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/otykier/subscriptions","organizations_url":"https://api.github.com/users/otykier/orgs","repos_url":"https://api.github.com/users/otykier/repos","events_url":"https://api.github.com/users/otykier/events{/privacy}","received_events_url":"https://api.github.com/users/otykier/received_events","type":"User","site_admin":false},"created_at":"2017-04-28T09:54:08Z","updated_at":"2017-04-28T09:54:08Z","body":"Thanks @SQLBent \r\n\r\nAs for point 3, it is currently not possible to set this through Tabular Editor, as the Database object is not currently accessible in TE (it's read-only). I will look into the possibilities of making this object accessible in TE. However, if you're going to use PowerShell anyway to process the model or parts of it after deployment, you might as well use that to set the database description too. \r\n\r\nIn @SQLBent 's example, you'd just have to add the following line before calling `$db.model.SaveChanges();$:\r\n```powershell\r\n$db.Description = \"Your Description Here\";\r\n```"}}
{"actor":{"display_login":"otykier"}}