I didn't check the attached qvf, but it can be some reason:
- Underlying data set. The user table and the other table have one to many relationship.
- At the visualisation you are choosing so dimensions that have one to many relationship.
- The relationship beetween tables isn't definied (check the data model viewer), I don't know, if it can be a problem with dimensions, with measure it is sure a problem.
Hi undergrinder ,
Thanks for your reply.
In my sample i am using 3 kind of tables
1.)user table - table using for purpose to get details from quicktips table according to user_id,here each user as clients and each client have different user.
2.)client table - to get client id for users
3.)quicktips tables - get details according to user_id from quick tips table.
Here each client will be having different user.so there is no one to many relationship,as every user_id will be having its client and getting details according to user_id.
Please look into qvf file and please help me on this
The First table at the sheet:
All fields are from USERQUICKTIPSANSWERS table.
Please look at your data model.
The USERQUICKTIPSANSWERS table connect to QUICKTIPSQUESTIONS on quick_tips_question_id
The QUICKTIPSQUESTIONS table connect to USERQUICKTIPS on quick_tips_id
The USERQUICKTIPS table connect to USERS on quick_tips_userid. (Users table contains quick_tips_client id)
These connections have an key change, the connections aren't proper defined.
Try that to comprehend the problem:
Add quick_tips_id to the table on the top (based on QUICKTIPSQUESTIONS table),
You can see, that all value is the same (133).
Add quick_tips_user_id (based on USERQUICKTIPS)
And you see it have a wrong relation.
Hope this helps.