Published on InterSystems Developer Community (https://community.intersystems.com)

Página Inicial > Fact Table com 1 registro

Pergunta
Henrique Dias · Dez. 16, 2020

Fact Table com 1 registro

Fala pessoal, tudo bem?

Criei uma tabela com 100k registros. No SELECT, retorna tudo belezinha. No entanto, quando tento criar um cubo utilizando essa tabela como base, o cubo é compilado com sucesso. No entanto, quando faço o BUILD, ele gera apenas 1 fato.

Alguém já se deparou com alguma situação similar?

Alguns detalhes:

Class diashenrique.olist.data.order Extends %Persistent
{

Property customerID As diashenrique.olist.data.customer;

Property orderStatus As %String;

Property purchaseTimeStamp As %TimeStamp;

Property approvedTimeStamp As %TimeStamp;

Property deliveredCarrierDate As %TimeStamp;

Property deliveredCustomerDate As %TimeStamp;

Property estimatedDelivery As %TimeStamp;

Index OrderStatusIndex On orderStatus;

Index customerIndex On customerID;

Index purchaseIndex On purchaseTimeStamp;

Storage Default
{
<Data name="orderDefaultData">
<Value name="1">
<Value>%%CLASSNAME</Value>
</Value>
<Value name="2">
<Value>customerID</Value>
</Value>
<Value name="3">
<Value>orderStatus</Value>
</Value>
<Value name="4">
<Value>purchaseTimeStamp</Value>
</Value>
<Value name="5">
<Value>approvedTimeStamp</Value>
</Value>
<Value name="6">
<Value>deliveredCarrierDate</Value>
</Value>
<Value name="7">
<Value>deliveredCustomerDate</Value>
</Value>
<Value name="8">
<Value>estimatedDelivery</Value>
</Value>
</Data>
<DataLocation>^orderD</DataLocation>
<DefaultData>orderDefaultData</DefaultData>
<IdLocation>^orderD</IdLocation>
<IndexLocation>^orderI</IndexLocation>
<StreamLocation>^orderS</StreamLocation>
<Type>%Storage.Persistent</Type>
}

}
IRISAPP>d ##class(%DeepSee.Utils).%PrintBuildErrors("OrderCube")                                          
0 build error(s) for 'OrderCube'

IRISAPP>Do ##class(%DeepSee.Utils).%BuildCube("OrderCube")                                                

Building cube [OrderCube]
Existing cube deleted.
Fact table built:                 1 fact(s) (1 worker(s) used)
Fact indices built:               1 fact(s) (1 worker(s) used)

Complete
Elapsed time:                  0.209013s
Source expression time:        0.000003s

   

Abraços,

Henrique

#Analytics #InterSystems IRIS BI (DeepSee)
Product version: IRIS 2020.4
$ZV: IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2020.4 (Build 524U) Thu Oct 22 2020 13:04:25 EDT

URL de origem:https://pt.community.intersystems.com/post/fact-table-com-1-registro