Yeah exactly. I struggling to include cost group in the hierarchy as you rightly said it is many to one account. What could be the solution ? Should I take...

This issue is happening only when I include cost group column in the hierarchy. I am just wondering, why hierarchy works only if I don't include cost group column ,...

Hello Jeff,

What are you suggesting by lesser environment?

The story is:

we use visual studio 2019 but ssis packages are made with 2016 settings and we are running the cube on 2016...

Hi Thom, I am trying to understand your question . What do you mean by Validation mechanism?

I declared a variable with some default value 'the value is generated by script...

I declared a variable to hold the file to pass to send mail task. I had a given a value like 'The value is generated by scrip task'  to the...

• This reply was modified 4 years, 11 months ago by  Charmer.

Finally, issue is fixed which was a silly and it's done. 🙂

The issue that I have right now is that when I try to pass the entire path of the file along with the file name to a variable , and...

I have tried to achieve this using script task by validating the count of the columns in the sheet. I am validating against a fixed count(using variable from configuration table)....

Okay, thank you.

It should have been handled gracefully but instead the job is designed in such a way. It simply calls the master package and if any of the child package gets...

So I guess when child package completes, it updates the queue table using event handler and also we will have to re-run the master package manually?

They are two different measures from two different measure groups. Yes I tried creating a calculated measure and using that measure in the formula but it did not work.