Post reply

Microsoft SQL Server Analysis Services

  • March 19, 2010 at 10:53 am

    #218066

    We have a business requirement to supply a data cube to help analyse Credit Card Fraud.

    One of the fields in the cube is currently encrypted - credit card number.

    Is it possible to decrypt the field when it is dragged into the results area of the cube?

    We have a Stored Proc that decrypts the field for reports can the same process be used for Cubes?

  • March 19, 2010 at 11:43 am

    #1136930

    I haven't tried it but you *might* be able to utilize the Stored Procedures functionality of SSAS for this too. I think they're all .net classes, referenced in memory by the SSAS process, so assuming you could convert your TSQL Stored Proc (which may already be an extended stored proc, making life easier), this might be possible.

    Some examples can be seen in the stored proc project on codeplex (here).

    HTH,

    Steve.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply