Not sure I understand the problem?? Why not use the flat file connection, set it to fixed length for the format and load up the data?

I always logged to a db table, are you set up the same way and if so, is the connection information correct?

Wondering if they also lose some reporting/analytical functionality by separating it from the rest of the Customer record? If you/they want to attribute this in *any* way then it's...

Seriously guessing this depends on what your fact is actually recording..... But assuming sales (when in reality, it's just as likely mining equipment moving round an opencut mine), then...

Glad you got it sorted! Didn't see your last post until now :-S If memory serves, you will have had to unblock 2383?

You don't need the full install, just the client components. It could be a port/firewall issue on the server, have you checked this? Can anyone else connect...

That's it for the table/s that are used in your dimensions, like I said, you'll have to interrogate the Partitions for each Measure Group too, to get your Fact references.

Best as I can tell, you're really really close 🙂

What you're looking for is almost a merge of these two approaches - you need a calc members in the Age...

Can you post your calc member MDX? Even a 'cleaned up' version where you change the names to protect the innocent?

Think of it in pieces... 🙂

The dimensions in a cube, are Database dimensions. So, (and there are different approaches for what you loop through first) if you loop through...

Use the SSIS SAP adapter? http://msdn.microsoft.com/en-us/library/dd299430.aspx

Absolutely agree, don't go trying to hit the tables directly, it gets ugly very (very!) quickly. You can also expose different BAPI's as...

Depends a little on how you're calling the 'rdl' (ie the report). If you're using the Report Control, then I think you can set parms in code behind. ...

Are you expecting a lot of volume? If it's small you could use the temporary storage and simply read it back into the flow.

The derived column definitely looks like it can't do what you want, however a Script transformation would probably handle that easily (with an additional function written to handle to specifics)....

It's 'doable', we have some clients running that way. As always, disk and RAM are pretty high on the 'get it right' list, CPU also counts but in my...