Post reply

1:M - build flat view with new 2008 features

  • December 7, 2011 at 3:40 pm

    #391067

    given a fund table with many classifications, how can I build a view that shows the funds, each classification and whether or not that particular fund is classed or not?

    How can this be done with new fancy features in 2008 and which method will yield the best performance results?

    fund_id

    1

    2

    3

    4

    classification

    fund_idclassification

    1 CASH

    1 UK

    2 GOLD

    3 CASH

    3 USA

    3 SHORT-TERM

    fund_idcashukgoldusaSHORT-TERM

    1 truetruefalsefalsefalse

    2 falsefalsetruefalsefalse

    3 truefalsefalsetruetrue

  • December 7, 2011 at 3:58 pm

    #1418412

    duplicate post. no replies please.

    Discussion already started here.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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