SSAS cube Deployment -
i trying hands on building cubes using adventureworksolap database. build trying do. concern want deploy cube server rest of team members can use cube datasource while generating ssrs reports (might other tools).
i have heard ssas not allows sql authentication. so,
1) how members access cube?
2) authentication changes need incorporate?
3) how can other developer using computer's ssms access cube , make changes (just can in oltp database)?
4) need prepare dashboard using cube. suggestions on one.
thanks in advance.
1) windows authentication
2) none.
3) once cube deployed cant change it. can change things partitions , roles, cant add dimension example. need change project on bids , redeploy it
Comments
Post a Comment