on 07-28-2015 4:23 PM
Hello,
I need to use a scripted calculation view for one of the requirement. I have a fact table and 10 dimension tables and need to join all of them. Though, the requirement could be easily done in an analytical view the requirement is to get this done through a scripted calculation view. My question is, if i use one query and join all the attribute views in it , would that affect performance?
Like , var_out = select field1,field2 from fact table inner join attribute view 1 on <condition> inner join attribute view 2 on <condition>...
Is the above query ok on performane or is there an better way to handle the above requirement in a scripted calculation view?
Thanks,
Prem
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any thoughts?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just about a single hour before urging up your question? Seriously?
Personally I view this forum as a place for voluntary knowledge exchange - not as a on-demand quick answer dispenser.
Impatiently demanding answers like this really makes me feel to not answer.
Good luck with this approach.
- Lars
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.