November 8, 2018 at 11:50 pm
Hi,
I have calendar dimension. On top of it, I have created a view. I use this view in my tabular model. I am processing this model through agent job using SSIS package. Everything is working fine but when month change, the month is not coming correctly. Once I do a manual process of my model it will work again. I am not able to understand why the only month did not get an update. Am I missing something? Appreciate your help here.
November 14, 2018 at 6:17 am
Without considerably more detail, there's no way to know what you mean by "the only month did not get an update". As written, it would suggest that you have a single month worth of data, which is not typically what happens in an SSAS environment. You'll have to be much more specific and explicit as to what, exactly, is happening, and what you are working with in detail. We can't see what you are seeing, and from what you typed, we still can't see anything.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 17, 2018 at 12:16 pm
The data must be updated and the thing is that if the calendar module is being made in the database and the SQL query is not applicable to the DB, then the SQL programmer has to update the database and it has to be connected to the Windows platform through Windows module installer worker high CPU and then the access of that can be taken.
November 19, 2018 at 12:23 pm
markj.ed9878 - Saturday, November 17, 2018 12:16 PMThe data must be updated and the thing is that if the calendar module is being made in the database and the SQL query is not applicable to the DB, then the SQL programmer has to update the database and it has to be connected to the Windows platform through Windows module installer worker high CPU and then the access of that can be taken.
Unfortunately, I have no idea what you mean by any of that. It might as well be gibberish. Your use of the English language is going to have to improve considerably or you'll have to find someone that can explain your challenge in English such that it needs no further explanation. At the moment, I've gotten nothing from your response. Example - the phrase "then the access of that can be taken".... totally meaningless without any context. The rest of the sentence is a bit of a run-on, as the words "the SQL programmer has to update the database and it has to be connected to the Windows platform through Windows module installer worker high CPU" make absolutely no sense whatsoever after the word "database".
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply