Multidimensional Modeling with PQ – Auto-Extend Entities

Multidimensional Modeling with PQ – Auto-Extend Entities

Craig Hatmaker Craig Hatmaker

Craig Hatmaker

Microsoft MVP | BXL | 5g Modeling Founder

发布日期: 2021年11月2日
+ 关注

Table of Contents

  • Project Planning?– Project Introduction and Project Plan
  • Permutations?– Merging Queries to Create All Permutations for Calculations
  • PQ Calcs?– Calculate values in PQ
  • PQ Functions?– Creating Functions
  • Auto-Extend Entities – Creating Auto-Extending Excel Tables for Entities
  • Auto-Extend Associations – Creating Auto-Extending Excel Tables for Associations

No alt text provided for this image
No alt text provided for this image
No alt text provided for this image
No alt text provided for this image
No alt text provided for this image
No alt text provided for this image
No alt text provided for this image
No alt text provided for this image
No alt text provided for this image

要查看或添加评论，请登录

Craig Hatmaker的更多文章

  • Emulating Solver with LAMBDA
    2025年3月20日

    Emulating Solver with LAMBDA

    Introduction Excel’s Solver is a powerful optimization tool, but some companies impose restrictions on its use. A…

    3 条评论
  • Rollingλ(): 5g Function for Rolling Calculations
    2025年2月22日

    Rollingλ(): 5g Function for Rolling Calculations

    Introduction Excel's LAMBDA functions have opened up incredible possibilities. 5g functions are LAMBDA functions…

    10 条评论
  • TRIMRANGE() and Trim Refs
    2024年12月17日

    TRIMRANGE() and Trim Refs

    I cringed when I first saw TRIMRANGE(). "Oh great," I thought, "another reason for people to avoid learning tables.

    6 条评论
  • Intro to LAMBDA - Lesson 16 - Simple Corkscrew
    2024年11月23日

    Intro to LAMBDA - Lesson 16 - Simple Corkscrew

    I could use your help. I am preparing a virtual work session for FMI on "Intro to LAMBDA.

    13 条评论
  • Programming with LAMBDA - Prime Numbers
    2024年10月11日

    Programming with LAMBDA - Prime Numbers

    LAMBDA makes Excel "Turing Complete." Virtually all programming languages are Turing complete.

    2 条评论
  • Timing LAMBDAs with LAMBDA
    2024年9月7日

    Timing LAMBDAs with LAMBDA

    I recently created a 5g function. It worked great but two friends suggested faster ways to accomplish the same thing.

    2 条评论
  • Create a 5g Function: RunTotRowsλ()
    2024年9月5日

    Create a 5g Function: RunTotRowsλ()

    NOTE! This article was written with assistance from Google's Gemini AI. Introduction In the world of Excel, complex…

    7 条评论
  • Live 5g Instruction
    2024年7月17日

    Live 5g Instruction

    The only live 5g training session starts July 30th. Register here: https://maven.

    4 条评论
  • From Formulas to LAMBDAs
    2024年7月9日

    From Formulas to LAMBDAs

    I have just completed creating a small class on converting a group of formulas into a single LAMBDA function. It is…

    1 条评论
  • Stairway to ... LAMBDA?
    2024年6月24日

    Stairway to ... LAMBDA?

    I use Excel for everything. I need some stairs from my yard to the forest floor below.

    19 条评论

社区洞察

其他会员也浏览了