Data Modeling Question

[israrkhan]

Hi Community,

i have data modeling question,  let say i have three tables

table1, table2, table3

table1 conected to table2 by DealerCode, and table2 conected to table3 by Targetdate.

so now if i add, any column from table1 as a dimension, and i do sum(value) on a column in table3, so will it work,

i mean will it group data on dimension. 

and second thing is table viewer loads all the data, or only some data for view?

see the image please:

Thanks.

in the image created is date and has daily 1 value, and the target is monthly target which has monthly 1 value..

[giakoum]

Hi.

it should work, since this is stantard Qv behavior. Of course, if created is daily and targets are inserted monthly, then on every day you will see the monthly target sum.

Not sure if that is what you asked, please explain if not.

Preview only loads some of the data, not all.

[#3]

Hi IsrarKhan,

Yes it is a standard behaviour. take care of the cardinality, as usual.

Preview is loading some lines only. if I remember well, it is 1,000 or 10,000 lines.

Fabrice

[sundarakumar]

Yes it will work fine and in preview you will be seeing only a preview of the first 1000 table rows will be shown

-Sundar

[Peter_Cammaert]

Preview shows first 1000 records according to Load order.

Peter

[israrkhan]

"Preview only load some data not all"...

so how to validate,that the figures are correct, if you are reading from a large text file..?

thanks for the reply...

[#7]

A real table in the GUI

Fabrice

[#8]

Also some function like NoOfRows('TableName') that return the number of lines for example

Fabrice

[israrkhan]

Thank you guys,

for your's helpful answers.

[israrkhan]

Hi Fabric,

Nice one answers.

last question is, if two date are in different format, one is DD/MM/YYYY and the other is MM/DD/YYYY

if i link them, will they work, or format should be same...

Kind Regards

Khan