Management percentage on tenancy

[elizabethhamlin]

Hi I am aware that you can get the management fee from the property but this can differ on the tenancy so please can you arrange to pull the management fee on the tenancy through to the data warehouse

Thanks

Lill

Specification

• Project: Analytics Schema
• Enhance Tenancies model to include management fee amount/percentage as per lettings property fields (but for the tenancy). We should NOT fall back to the values on the property at this time if they are not set explicitly against the tenancy as this should be left up to the report developer as different users will want different behaviours
• If letting fees are not included in this model we should add them at the same time for consistency
• Remember to update analytics schema documentation with these changes

[github-actions[bot]]

This issue has been updated and moved to our ‘Near Term’ column (typically completed within 0 - 4 months). We have assessed the effort required and outlined a technical specification - please take the time to review this detail. When we're ready to schedule the issue, it will be assigned to the relevant board where you can continue to track its progress to completion. For more information on our processes, please click here

[elizabethhamlin]

Hi @plittlewood-rpt I cannot see that this is available in the data Warehouse yet. Can you point me in the right direction.

Thanks

Lill

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[plittlewood-rpt]

Hi @elizabethhamlin you will need to refresh your data share in the data warehouse app to see the new fields.

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[elizabethhamlin]

Hi @plittlewood-rpt I have it now but it does not appear as a column in my Power Query in Power BI so I cannot merge this column into the tenancy alterations table. It should appear after periodic but it's not there. I need to be able to merge the queries so I can work out what the management fee was before the increase

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[plittlewood-rpt]

Hi @elizabethhamlin I've just checked your data warehouse via Snowflake and the fields are definitely there so it's likely you need to refresh the view of your data in Power BI

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[elizabethhamlin]

I have loaded in just these tables into a brand new report and it isn't there

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[plittlewood-rpt]

Unfortunately I can't assist with Power BI. This is your analytics schema in Snowflake so the fields are definitely in there ready for you to use.

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[elizabethhamlin]

Hi @plittlewood-rpt I have looked into this and is the tenancy management fee a calculated column? If so is there no way that it can be different as I cannot model this in it's current form. We need to be able to match the old management fee with the new management fee on the tenancy alterations but can't as the data you have added does not appear for me to be able to merge the queries together. Also you have said that this shows in Snowflake but the tables I pull are from the below so are they in the correct place -

As you can see here, the columns are not there -

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[plittlewood-rpt]

Hi @elizabethhamlin no it's not a calculated column. Can you try logging into Snowflake directly yourself to see if you can see the fields (just go to the Snowflake URL and login with the credentials you've set up in the Data Marketplace app

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[elizabethhamlin]

I'm an idiot. It was the type of the data my end. It had summarised it so wouldn't pull through. Fixed it and thanks for your help :)

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here

[plittlewood-rpt]

Don't be so harsh on yourself on a Monday ;) Thanks for confirming, glad you've sorted it

[github-actions[bot]]

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here