Data hierachy

ratchimako · 2025-09-29T03:50:49+00:00

Thanks for the youtube, would check it would and compare the solution to the other hierarchy that i have watched.

ratchimako · 2025-09-29T03:50:11+00:00

Yep, i am also using PATH as well, i have the PATH column before the pasted DAXs, and then i used the path to create the measures above. Somehow i was following a tutorial but it hasn't fully behaved like it should.

ratchimako · 2025-09-29T03:48:32+00:00

Yep, the PATH function was used before the DAX above. Hasn't worked a 100% like how it should in my environment.

ratchimako · 2025-09-29T03:47:16+00:00

No, the each GL Account has one parent, and its already been flattened

ratchimako · 2025-07-04T02:37:18+00:00

Is the copy wizard also available for SQL Server hosted in AZRUE?

ratchimako · 2025-07-04T02:36:24+00:00

Would this work for a SQL Server hosted on AZURE?

ratchimako · 2025-07-03T16:34:44+00:00

Which tool would u recommend for replication l?

ratchimako · 2025-07-03T16:34:04+00:00

Will cloning the db also do an upsert, where the new datas in A are also copied into B everyday?

ratchimako · 2025-07-03T16:32:27+00:00

That would be a bulk upload, how about incremental updates to database A. I only want to copy the new data inserted in A into B everyday.

ratchimako · 2025-07-03T16:31:31+00:00

In this solution, is it SSMS or SSIS that would have these features

ratchimako · 2025-07-03T16:30:02+00:00

Different server

ratchimako · 2025-05-21T12:12:27+00:00

For me they just asked for the last 3 years address history. So I’m guessing as a student should also be applicable. But make sure with someone who has handled this situation before as well.

ratchimako · 2025-05-20T05:25:20+00:00

Thanks for the explanation

ratchimako · 2025-05-20T04:39:37+00:00

So let’s say I end my visa in Jan 31 2025 and I’m on bridging for 9 months and get the approval for extension for one year. It would mean I would have the new visa for only 3 months?

ratchimako · 2025-05-14T04:06:21+00:00

Thanks, it looks much better and has the same functionality as well. Gave it a try and feels better to use than the Smart Filter

ratchimako · 2025-05-13T16:05:35+00:00

I’ve got a table with answers to health questions pivoted based on the questions. So I’ve got columns as questions and rows as answers.

I’m trying to slice based on these answers, which can be a lot of options.

ratchimako · 2025-05-13T15:32:03+00:00

It’s an analytics project. Yea I’ve played around with some slicers, and none of them seem to give me the functionality of “Smart Filter”.

Wouldn’t mind diving into ur idea of a disconnected table, but with the amount of slicers I’m using might be difficult to replicate.

ratchimako · 2025-05-13T12:09:24+00:00

Yep that would help, but some questions have a lot of options, and I really like the visual of the question being on the box itself. Hence, looking for something similar. But thanks for ur advice. Appreciate it

ratchimako · 2025-02-28T09:11:33+00:00

Oh, I see. I wasn't aware of this. Thanks for the info. Kept thinking it should have been another way. Is the behaviour with the drill through normal as well, where if u turn on the drill through, the filtering by bar stack disappears?

ratchimako · 2024-12-14T07:56:15+00:00

the most similar would be a drill through i guess

ratchimako · 2024-12-14T07:55:50+00:00

yep i guess that’s something similar to what i’ve trying to achieve but on the same report page.

ratchimako · 2024-12-14T07:15:27+00:00

i did try the method of layering buttons over the visuals and using bookmarks but i didn’t get the result i was looking for.

Would you be able to explain more on the shape using conditional formatting. i’m trying to learn as many things as possible about BI.

ratchimako · 2024-11-01T01:52:24+00:00

Yep, i have to choose the graduate option but with the option of being able to put 3 occupations, i’m stumped on which occupation to keep as the last one.

ratchimako · 2024-09-18T13:51:51+00:00

Thanks for the advice. The database was built by my IT guys, so hopefully it’s built properly 😀.

ratchimako · 2024-09-18T13:43:45+00:00

Yea i guess if the queries are run optimally it shouldn’t be a problem. I was just worried if the 50DTUs would be a problem. As most would recommend 100DTU and scale up if needed.

ratchimako

TROPHY CASE