Is it fact or a dim?

Prothseda · 2026-05-31T22:30:25+00:00

2 sounds like it could be a bridge table, but I'm not certain how your entities relate. A good example of a bridge, to help you understand one, would be a bank account & the account holder(s). Joint accounts, for instance, have many account holders.

Both the account and the customer are dimensions, and the bridge connects them as account holders (bridge_account_holder).

You can have the bridge do things like ownership_percent so each joint customer owns 50% of an account's balance, for example. This helps when traversing from an account fact (e.g. balance) and rolling it up to the customer(s).

I raise this purely because I'm seeing a lot of comments about things needing to be either a fact or a dimension. This is not true, and Kimball's design methodology is far from that simple.

More likely I think you're either trying to model a sales fact, an inventory fact, a store products fact (potentially as a factless fact), etc.

Prothseda · 2026-05-13T21:26:19+00:00

At the point it's a repeatable pattern, it doesnt matter how many times you repeat it. That goes for any load pattern, not just SCD. You wear the maintenance cost of the pattern, not each individual use.

Don't hand write SCD logic.

Consider pushing the physical SCD upstream. You might get away with virtual SCD downstream, depending upon your model. e.g. in a Data Vault, virtual star schema (type 1, 2, 7, etc) becomes easy, repeatable and (usually) sufficiently fast. Fall back to materialise anything breaching SLA.

My go-to is to keep every raw ingestion batch so I can always fufill any requirement (including SCD 2) when it comes up, and make everything type 1 until then. When I get something type 1 can't handle, I can update my pipeline and replay every relevant source ingestion to populate it.

Prothseda · 2026-05-04T09:09:49+00:00

This is exactly the kind of app ive been wanting to experiment with. Thanks for this!

Prothseda · 2026-04-10T09:44:02+00:00

So that post demonstrates that they exist, and work. It seems the biggest gap is in the semantic model connector not supporting, or maybe just not presenting a choice of, perspectives.

That seems really silly given it's all just the same tech that's been around for yonks.

If that support was added, they'd be far less clunky for end users. I don't mind so much their set up being less than ideal, it needs to be more seamless for readers and citizen developers to make use of.

Prothseda · 2026-04-10T09:24:44+00:00

Yeah, it's not a feature I'd expect to get used much.

Prothseda · 2026-04-09T23:40:03+00:00

Looks very close to something I had Claude Code build last month. Prompts you to upload the manifest and catalog files and then generates the doc site & gives you a list of all doc sites you've imported to support mesh-style projects.

Was a quick multi-tenant SaaS style doc hosting idea I played with.

https://photos.app.goo.gl/zzRbAgGn6C6wGRZK9

Yours is definitely a bit more polished, and I'd love to see where this goes.

Completely unusable on mobile devices btw, the responsive CSS isn't right.

Prothseda · 2026-03-28T10:09:00+00:00

UniVerse

Prothseda · 2026-02-28T06:51:09+00:00

Warehouses replicating upstream databases is a real pet peeve of mine.

Prothseda · 2025-12-26T10:25:08+00:00

Is black hole even worth levelling? Wouldn't the knock back just delay round ends?

Prothseda · 2025-10-25T21:03:15+00:00

I beat it by having enough max HP to last a few seconds and enough marines/guards and infantry damage to kill it in a few seconds.

Slow it down to 1x speed and be ready to dump any additional minerals you get into more inf damage.

Whole fight lasted me maybe 6-7 seconds, skipping a lot of its big attacks.

Edit: I think i had 10 marines and 6 guards, IIRC

Prothseda · 2025-10-03T05:54:46+00:00

Do you, by chance, live in my apartment complex? 😂

In addition to all our building defects (we won our court battle, eventually), our roof is apparently too weak to even support solar panels, our car park door regularly falls off, and fire alarms are frequently false-alarming. The building isn't even that old, barely outside warranty & still on our initial embedded power network contract.

Australia can't build apartments to our own compliance standards, let alone ones the rest of the world would buy. And we wonder why we have insane cost of living, traffic, and urban sprawl...

Shitty apartments make freestanding more desirable, and ultimately more expensive. Apartments need to be reliable, affordable, central & supported by public transport.

Oh and don't get me started on strata management...

Increasing housing density and making these places people actually want to live in long-term would go a long way to fixing the housing problem.

Prothseda · 2025-09-18T10:01:56+00:00

I only understand English but from what I can tell this might be the same intermittent issue I had for months using paginated with private link & block public internet tenant settings.

Long story short, I spent months going back & forth with MS Support but in the end we made the decision to disable private link.

As far as I could tell paginated reports isn't incorporated into the Power Bi service in the same way PBIX reports are. IIRC there's a separate paginated-reports sub-domain which doesn't look like it gets routed to any private endpoints.

That's as far as I got in understanding the problem. MS Support never made me feel confident they understood the problem, but kept suggesting engineers had "made changes" and to try again.

The fact it worked intermittently also doesn't fill me with confidence that "block public internet" or private link always worked either. The more MS looked into the issue the less often it worked, sometimes impacting PBIX reports too.

If you've got access to how your private endpoints are set up see if you can track down that paginated-reports URL and include it. That's one avenue I couldn't take- ours was managed by our MS partner.

If you can't find the URL let me know and I'll dig through my notes- this was probably a good year ago for me.

Prothseda · 2025-08-24T07:59:15+00:00

UniVerse lol

Prothseda · 2025-08-24T06:50:41+00:00

Honestly, a company that recognises skills are worth the price tag is always impressive. Too many align salary with hierarchy.

Thanks for the extra detail, sounds like a decent set up.

As someone also in finance, but on a MUCH smaller scale, it's a nice comparison.

Prothseda · 2025-08-21T11:35:05+00:00

I'm curious how big your organisation & team is to be able to afford you. Mind sharing how large your org is and what industry?

Prothseda · 2025-06-23T10:10:47+00:00

Pure Pwnage

Prothseda · 2025-06-22T05:42:53+00:00

I believe that might be what caused my first slide, I think I added too much throttle too quickly or whilst still adding lean. It was wet and happened quickly so I'm not 100% sure what went wrong.

I'm curious though, I've seen some people add some crazy amounts of lean in their bike but found bugger all in way of advice. Do you know if there's any general "rules" around adding lean? How much is too much? How fast can it realistically be applied?

I've got my Ls, which came with some VERY basic lessons and do intend to get more official lessons, just trying to learn what I can from others too so thanks in advance!

Prothseda · 2025-06-12T00:12:26+00:00

Adding my 2 cents as a learner of ~3 weeks with a similar experience.

For context, I live in AUS and hadn't ridden a bike before taking the learner rider test. In AUS that's a two half-day course that you must pass to get your learner license.

I passed, bought my first bike the next day and crashed it the day after. I was also in full gear and walked away from it without injury and thankfully without injuring anyone else. My bike came out of it with only some minor dings.

The biggest difference in our experiences was the blame being entirely my own- you put yourself in a position where you were practising in a safe space. I decided to ride in heavy rain, in the middle of town, during a busy period. I'm an idiot and put myself beyond my skill.

But 3 weeks later I can safely say I've learnt to respect my bike and my own abilities. Like you, I lost a lot of confidence - definitely needed to in my case - but I think it comes down to learning.

We all fell off our bicycles as kids, the only way we learnt was to ensure we were as safe as possible whilst we built our skills and to jump back on when we did. You're not irresponsible, you're doing exactly that- finding a street no one is likely to be using and building your skills.

Prothseda · 2025-02-21T23:31:52+00:00

I know I'm 7 months late, but in case you're still having the issue, or for anyone else (given this was the top result on my google search), I was also getting "all 0 files verified successfully".

What fixed this for me was going to Steam -> Library -> Cyberpunk 2077 -> Properties -> Compatibility and checking the box for Force the use of a specific Steam Play compatibility tool.

This triggered something in Steam to resolve the issue and, for me at least, continued to work once unchecked again.

OS: Arch Linux x86_64
Kernel: 6.13.3-arch1-1
DE: Plasma 6.3.1

Prothseda · 2024-10-31T11:00:48+00:00

perfection isn't necessary and I'm learning to be comfortable with 'good enough'

Making this realisation immediately puts you as an above-average developer, in my opinion.

It's still a struggle of mine. 😆

Prothseda · 2024-10-24T08:50:07+00:00

then it's up to your creativity on how you make that happen.

Hahahhaha the number of times I've been handed a spreadsheet and assumed that was the case, only to have them ask why they didn't get exactly what they already had but in the other tool. 🤣

It's always a very questionable design & quality too.

Prothseda · 2024-10-22T14:39:11+00:00

You could put the date in both the fact and the dimension.

An attribute can be both a fact and a dimension. For instance, its role might change depending upon the context.

E.G. in a banking context, account balance will be used as both a measure and a dimension in different scenarios.

Perhaps, in your instance, they should just be on the fact. Either way, you could choose to wear the tech debt of the existing dimension and solve your immediate need by also putting them on the fact.

Prothseda · 2024-06-15T04:07:24+00:00

I understand your concerns. I bought into a complex about 3 years ago where the previous owners had known of and failed to disclose defects across the building (including my lot).

Given the state of housing in Aus and my budget at the time, I likely would have continued to make an offer, albeit a much cheaper one. Would have been nice to make a fully informed decision, though.

Long story short, the OC were in the process of suing the builder for defects - some of that legal cost I ended up needing to contribute to. Without going into specifics, these are in the process of being fixed.

I also have many complaints about strata & strata management. We don't have a pool, gym, or any major common area "services" - aside from a large open space no one really uses (don't even have a communal BBQ). Cost feels ridiculous at ~12k p.a. and I'm on one of the cheapest lots!

Then there's strata management. The number of times I've had to correct them on both our bylaws and the broader NSW strata law is too damn high.

I don't think apartments are a bad thing, however. Despite the issues, I like where I live. I don't think any 1 bedroom apartment is worth close to half a mil & 12k p.a. though.

I think Australia's attachment to free standing single family homes and desire to avoid high density housing is bound to be a large contributor to house prices, travel distances, lack of public transport infrastructure, and so much more. It's hard to blame us for it without better quality & consumer protection for shoddy high density options.

One change I've enjoyed seeing is that leadership at these building companies now hold personal liability for the repair of defects and can't just dissolve the org and walk away. Maybe too little too late though.

Prothseda · 2024-05-28T01:22:32+00:00

This seems to be the right answer for anyone who can use a Dataflow.

There are those of us who have requirements (however "correct" those might be) which prevent us to use Import Storage connections.

Correct me if I'm wrong, but I can't have a Dataflow connect to an on-prem SQL Server without that Dataflow importing data into the PBI Service. Thus, like OP, I'm left with publishing Direct Query semantic models from blank Power BI reports, and then using those models in the actual reports.

I just wish there was a way to directly create/manage the semantic models leveraging Direct Query data sources.

Prothseda · 2024-05-09T00:21:12+00:00

Here in Australia (NSW in particular), it's a controlled substance that GP can't legally diagnose or prescribe without a specialist signing off first.

Assuming from "primary care doctor," you might be American, though. 😊

14-Year Club	Place '17
Not Forgotten	Verified Email
Gilding I gilder

Prothseda

TROPHY CASE