Hi when i try to do this command i get the following error

Invalid hex test for encrypted parameter

this is what am running i don;t show the complete encyrped...

In my past experinces i've always found this to be an issues with the data , so if i were you i'd check your data. For a cube to build...

hi make sure you have all the references data in you Dim table or that you are not missing any key colums in your fact table that cannot join to...

what is the error your getting also why type of security option have you used on the data source ?

I applied the calculations in the cube design and it work fine for me..

Hi when i display this in in a pivot table it seems to add up the margin figures in the total how do i get them to recalculate again ?,

at...

this worked for me thanks , but can i use the getdate()-1 in the expression ? i need to use the -1 to look for the folder for the pervious...

I've a foreach loop in ssis, that loops through a dir that has about 30 files in it. The format of the file name is xxx_yyyymmdd_z.txt and xxx_yyyymmdd_zz.txt

I...

Hey yes i was working with this concept but the problem am having is that i can't substring the file name.

I can get it to work for any letters in...

Hey there is a sample of my report.

It has or could have many report pages in the one file.

report ...

Can i attach a file here will i just paste in a smaple file.

I see so there is no other way of doing this ? as am not a programmer now so this could be out of my league now.

Ok i got a sample file through and its like i described above.

They are sales reports so i have a report heading with name and seq number &...

I will once i get a sample of it myself am awaiting it from another person. All i was told to have a look into seeing if this is possible...

Ok sorry i should have mentioned the types of files someof them are .txt and others a .csv. I'd like to use SSIS to import them in.

So With SSIS...