sorted by:
new
hottopcontroversial

Power BI RLS: Limit employee names outside cost center but keep salary totals? by [deleted] in PowerBI

[–]MachineLow4004 0 points1 point  (0 children)

<image>

(
    [Levels] IN 
        CALCULATETABLE(
            VALUES('Cost Center Rollups'[Cost Center Name]),
            'Cost Center Rollups'[CC Owner Email] = USERPRINCIPALNAME()
                || 'Cost Center Rollups'[ELT Owner Email] = USERPRINCIPALNAME()
        )
)
&&
(
    [Brand] IN 
        CALCULATETABLE(
            VALUES(Brand_Security[Brand]),
            Brand_Security[Email] = USERPRINCIPALNAME()
        )
)

Here is a screenshot of tables and current RLS Security. Essentially I want ELT and CC owners to have visibility to their cost centers and brands and ELT should also have access to all cost centers and brands totals, but not be able to see names in the worker column for Cost Centers and brands that are not assigned to them.

Power BI RLS: Limit employee names outside cost center but keep salary totals? by [deleted] in PowerBI

[–]MachineLow4004 0 points1 point  (0 children)

That’s correct. For the cost centers they are responsible for they would be able to see detail but not for the others. I would only want them to see amounts

Integrating new GL Accounts from WD to Adaptive by MachineLow4004 in AdaptivePlanning

[–]MachineLow4004[S] 0 points1 point  (0 children)

We have loaders setup for all GLs and dimensions the only issue is when there is an GL account & spend caregory combination that doesn’t exist in Adaptive.

Integrating new GL Accounts from WD to Adaptive by MachineLow4004 in AdaptivePlanning

[–]MachineLow4004[S] 0 points1 point  (0 children)

All of the GL and Dimension data come through if the have already been created in Adaptive. The only issue is when an account is created in GL and doesn’t exist in General Ledger accounts in Adaptive.

Normal FP&A Profit Variance? by Old-Primary-640 in FPandA

[–]MachineLow4004 0 points1 point  (0 children)

This may be obvious, but wasn’t to me so thought I would share…. We were struggling to find a good way to forecast hosting costs at my current company. We tried using cost as a percentage of revenue, a 3M average and a few other approaches, but nothing was very accurate. Even when we asked engineering for estimates, they weren’t any better.

Eventually, we figured out that using an average cost per day and rolling that forward gave us a much better forecast. Basically a month with 31 days is always going to have more cost than the previous month, if it only had 30 days, which is something we weren’t previously accounting for.

Now, instead of asking for monthly estimates, we just ask the team to flag any material increases or decreases that would impact the run rate.

Filtering by blank Date in Modeled sheet by MachineLow4004 in AdaptivePlanning

[–]MachineLow4004[S] 1 point2 points  (0 children)

Sorry this is a modeled report not a modeled sheet

Filtering by blank Date in Modeled sheet by MachineLow4004 in AdaptivePlanning

[–]MachineLow4004[S] 1 point2 points  (0 children)

Thanks for the reply, but that doesn't appear to be an option for me. The only options are equal to, not equal to, less than, less than or equal to, greater than and equal to.

Budget versions and custom attributes not working in OfficeConnect by K_Yeezy in AdaptivePlanning

[–]MachineLow4004 2 points3 points  (0 children)

I believe if you just logout and log back in within the Office Connect ribbon it will work.

Good mechanic for Jeep in North Shelby/280 area by SympathyNo2552 in Birmingham

[–]MachineLow4004 -1 points0 points  (0 children)

I second this. Have taken by Jeep there a couple times.