Cheat CodeALTER TABLE mydatabase.fact_transaxion RENAME TO mydatabase.fact_transaction One thing I really hate dealing with various project is TYPO ERROR.How the hell the developers anyhow type and deploy table to database without double checking the name. ARGH! Luckily it’s pretty straight forward to rename the table in HIVE. Use the cheat code above to rename it.SimpleContinue reading “Hive Rename Table”
Tag Archives: Star Schema
PowerBI – Count Dimension by other dimension linked by fact
Cheat CodeCountTargetRows = CALCULATE( DISTINCTCOUNT(dim_TargetDimension[TheColumnName]), FILTER(dim_middle_man, CALCULATE(sum(FT_Transaction[Cost])>0))) Love-Hate relationship with PowerBI! I love the product as it’s super powerful BI tool, not to mention CHEAP (it’s free as matter of fact – PowerBI Desktop). It can do magic and wonder. Today I was asked how to create calculation for count of dimension rows but it’sContinue reading “PowerBI – Count Dimension by other dimension linked by fact”
My IT Cheat Code 