SSAS cube dynamic measure
$30-250 AUD
Teslim sırasında ödenir
Need help to answer this Question on Stack Overflow: [login to view URL]
I was able to generate a dynamic set as following:
CREATE DYNAMIC SET CURRENTCUBE.[Top 80% Sales Profit]
AS TOPPERCENT(NonEmpty( [Member].[Member Number].[Member Number].MEMBERS,[Measures].[Member Profit$ (Trn)])
,80,[Measures].[Member Profit$ (Trn)]), DISPLAY_FOLDER = 'Member Profit Contribution' ;
This is very good, but the users may not want the full list customers in Excel. The set can only be dragged into the Rows section of the Pivot report. Now I need help to associate all members of the dynamic set with a specified dimension.
Proje NO: #11630888
Proje hakkında
Bu iş için 5 freelancer ortalamada $225 teklif veriyor
Hi If you award me this job I will make a little changes to add members to specific dimensions. You need to slightly change your query and group it. As for me I am a veteran SQL DBA, working with SSAS for over Daha Fazla
Dear Hiring Manager, First of all thanks for creating an opportunity. Hope you are doing well. I will not propose what the maximum Freelancer do. I dont believe in copy paste Cover letter. I read your project details, Daha Fazla
Expert Data Warehouse and BI architect and SQL Server Developer backend ETL development using SSIS, T-SQL, SPS, udf, and more up to SQL 2014. BI Analytics in OLAP Cube development; SSAS, MDX, DAX and Dashboard Design Daha Fazla