Dynamics AX comes with 25 predefined roles in the Default Analysis Database. How do I create my own and associate this new Role with a Role within Dynamics AX?
I know the create Role wizard in SQL Server Management Studio, but I don t know how to tie my customer userprofile to Roles in my Analysis Database.
It seems there are no relations besides the naming. Conceptually the Roles are associated, but you are free to create Roles in SSAS independent of whatever Roles that exists in AX. So there you have it. It wasn t harder than that.
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. ...
