Hi, I am busy developing all our cubes in a tabula environment/models. The tabular interface in SSDT and powerpivot interface are identical. I havent got to far with writting DAX...

Thanks Gabriel, see what you mean. I did think about that. Not sure how I'm going to handle that.

These time diffs are going into a dimension and the reported on....

Thanks Kingston, looks much neater, will try that.

Gabriel, its just 6+5 =11 and should be 6 + .5 = 6.5 🙂

To get the hours as a decimal. else its 6 days + 5 hours = 11 days and should be 6 days + .5 hours = 6.5 days.

Not 100% sure...

Hey guys, just wondering how you do look ups? or if you should?

what if suzanne and bob had role information. which is kept in a role entity.

suzanne, fighter pilot

bob,...

sorry, thought I quoted you..

Eventually I did write a C# script that picks up the file, dynamically...

OK, got it working. In IE, reset settings.

Eclipse, I cant remember. But I did get it to work. I been off site for a few months so cant even remember what I did .

thanks guys. also helped me

I have had a similar problem. I tkink I solved it by setting the root folder. It was looking in the wrong folder.

what about using SQL to generate the file. Use SSIS to call the procedure.

?

similar to Johns solution.

I'd pull the data from excel into a table(SSIS) and then run the merge or update.

very cool. thanks

Agree. cant think of any way round it.

Done this before. used a controlling/audit table. Loop through the folder and add the file names to the table. You can have other audit info you might need in the...