Private Preview - features may change without notice
GramSpec
Architecture Spec API Reference Pricing About
Start free

Make the model · 3

A second process on the same model

The answer to “we have more than one process” and to “is this a warehouse?” A second report brings a second star. What the two share, the same customers, the same items, the same calendar, is built once, and their numbers can then be read side by side without one being added to the other.

Two stars on shared dimensions. One flow adds a second process to the same drawing and loads every star together, each shared dimension written once. The other is an analyst reading a number from each process side by side in Palmtree.GRAMSPECYOUR DATAWhoever knows thesecond processAn analystOne drawing, twostarswhat both name is one boxThe model viewwhich dimensions the starsshareOne load, every stara shared dimension writtenonceThe starstwo facts on shareddimensionsOne graph for bothboth facts in one fieldlistTwo questions, meton what they shareeach fact answers alonePalmtreea number from each, side bysideYour databaseread-only12345123 Two stars on shared dimensions. One flow adds a second process to the same drawing and loads every star together, each shared dimension written once. The other is an analyst reading a number from each process side by side in Palmtree.GRAMSPECWhoeverknows thesecondprocessAnanalystOne drawing,two starswhat both name isone boxThe modelviewOne load,every starThe starstwo facts onshared dimensionsOne graphfor bothboth facts inone field listTwoquestions,met on whatthey sharePalmtreea number fromeach, side bysideYourdatabaseread-only12345123
Blue circles add the second star. Green squares read the two side by side.

Adding the second star

  1. Someone describes a second process, on the same drawing. A thing they name that the model already has is the same box, and its page says which stars it serves.
  2. The model view shows what the stars share. The stars run across, each dimension two or more of them use is a band beneath, and what only one star has is listed under it. Every note on it comes from something a sentence declared.
  3. One load builds every star the words drew. It is a full load each time: what the words no longer ask for is taken away.
  4. A shared dimension is written once. Both facts point at the same rows of it, which is what makes the two joinable, and one calendar spans them all, so a month is the same month for every star. How each table was made is kept from every load and drawn as a picture.
  5. The stars are saved as one graph. Both facts stand in one list of fields, which is what lets a number from each be asked for together.

Reading the two side by side

  1. An analyst puts a number from each process on the same row. Sales and inventory by product, say.
  2. Each fact answers alone. One join across both would pair every sale of a product with every stock count of it and inflate both. So each fact is grouped by what the two have in common, the keys they saw are combined, and each answer is joined back to that list.
  3. A cell with nothing behind it says so. A product that was stocked and never sold shows no sales figure, not a zero, because zero is a measurement.