Skip to Content
author's profile photo Former Member
Former Member

Virtual characteristic or a regular charactersitic ?

Hello All,

i want to include a new characteristic 'zregion' in my cube, whose value gets computed on the basis of other characteristic values in the cube.

I'm confused whether i should populate this characteristic in the update rules or whether i should implement it as a virtual characteristic.

I think if i,

implement 'zregion' as a virtual characteristic then i will not be able to filter the query results based on the user specified values for the virtual characteristic(by creating a variable on the virtual characteristic for manual user entry).

Whereas if i have the values for 'zregion' in the cube itself, then it will allow me to filter the query results based of the user specified value for 'zregion' at query execution time.

Please let me know your thoughts on this, is my understanding right ?

Regards,

Sanjay

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 24, 2004 at 08:48 AM

    Hi Sanjay,

    your considerations are right, but the real trade-off is related to the performance impact (about a possible vrtual implementation...for details, see other posts in these forums)

    ...however, if you are able to reload your cube to fill your new char I would suggest to you to follow this way without any doubt !

    Implement your virtual char only if necessary (that is if you can't reload your cube..)

    Hope it helps !

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.