我是SSAS的一个新奇,具有一些理论知识。
我首先要做这项工作,也是执行工作中最简单的事情。
我在谷歌中搜索,但我发现的一点比我能抓住的要高。
请建议我开始一些良好的链接/文章(如果提供图表,则通过步骤加以改进)。
我指的是,没有任何浮游工作。 我不想说<代码>中的例子。 微软出版社,题为“2005年服务器分析服务步骤”(0735621993年)。 虽然这是好的,基本上有助于学习,但我(在完成头3章之后)认为,我需要安装一些已经考虑到的德国妇女联盟,而我并不希望这样做。
一切都应当从头开始,以便我能够适当学习,尽管时间可能不多。
同样,如果有人能够说明从一开始至尾(如制造层面、采取ube措施等)的后续步骤来创建SSAS项目,这对我和我这样的人民也大有帮助。
I have a many-to-many dimension in my cube (next to other regular dimensions). When I want to exclude fact rows in my row count measure, I usually do something like the following in MDX SELECT [...
我是SSAS的一个新奇,具有一些理论知识。
These are really hard to describe without going in-depth into the data structure, i ll try to keep it as short as possible while giving as much info as I can. I have a measure which is a monetary ...
I have a table with a list of contract line items in the form of CREATE TABLE contracts_lines ( contract_id integer, product_id integer, contract_line_start datetime, contract_line_end ...
Proficient with SQL but new to MDX, I am having trouble getting my head around this: I have a fact table that contains snapshots of account balances monthly. I need to roll up the balances as a semi-...
In a parent-child dimension in SSAS, the datamember is automatically named the same as the parent. E.g. Division X Risk Register Division X Risk Register Department A Risk Register Department B ...
I have the following query that gives me an extract (I am putting this into a CSV from my cube). I want to show the Total of all NRx in a column as the first column NRx and the rest of the NRx ...
First some background: I have the typical Date dimension (similar to the one in the Adventure Works cube) and an Account dimension. In my fact table I have daily transaction amounts for the accounts. ...
