Hybr®
Cloud Assert HomeDocs Home
2303
2303
  • Introduction
  • Features
    • Summary
    • Service Providers
      • Tenants Management
        • Tenant Onboarding
        • Tenant Portal Access for HYBR Admin
        • Tenant Portal Access for Support Users From Different Domain
        • Tenant Company Management
        • Company with AAD B2C
        • User Management
        • Subscriptions Management
        • Offers Management
        • Plans Management
      • Reseller Management
        • Reseller Offer
        • Reseller Plan
        • Onboarding a CSP Customer and Mapping it with Reseller
      • Billing
        • Credits
        • Microsoft CSP
        • Pricing Profile
          • Pricing Profiles Management
            • How to set Pricing List Import setting for meter
          • Update Pricing Profile from Excel
        • Cost Reset
      • Resource Management
        • Console connect requirements for imported VMs
        • Connection manager
          • Azure Stack Hub Connection Management
          • Azure
          • AWS
        • VM Template management
        • Param Spec
        • Network Management
        • Azure Integration
        • Policy Management
        • Linked Clone
        • Attach and detach networks
        • Delete Options
        • Backup
          • Veeam Backup Configuration
          • Scheduling a backup using Veeam
      • Microsoft CSP
        • MS CSP security consent process
        • Partner Center Refresh Token Expiry Alert
        • New Commerce Experience (NCE)
          • Transition from Legacy to NCE
        • Azure Reservation Management
        • Granular Delegated Admin Privileges
          • Bulk Transition of customers from DAP to GDAP
          • Default roles to be provided for relationship request.
      • Service Catalog
        • FAQ
      • Azure Stack Hub
        • Create and Publish Service Catalog offers
        • Configure Service Catalogue Plan
        • Pricing
        • Security Deposit for an Azure Stack Hub Offer
      • Customization
      • Administration
        • Application Settings
        • Admin Portal Access for Support Users
    • Business Intelligence Dashboards & Reports
      • Dashboards
      • Reports
        • Schedule Reports
    • Reseller
      • Customers Management
        • Customer Onboarding
        • Plans
        • Offers
      • Billing
        • Pricing Profile Management
    • Customer
      • Subscriptions
      • Resource Management
        • Virtual Machines
        • Connect a VM using browser
        • Virtual Networks
        • Resource Templates
        • Resource Groups
      • Microsoft CSP
        • CSP Operations and Status tracking
      • Software-Defined Network (SDN)
      • Company Registration
    • Cloud Cost Management
      • Cloud Dashboards
        • Azure Invoice Comparision
      • Collaborations
      • Resource Tagging
        • Data Processing Rules
      • Cost Allocations & Budgeting
        • Budgeting
      • Recommendations
      • Reconcilation
      • Getting started
        • Kubernetes
        • Azure
        • AWS
        • GCP
        • Tenant Company Creation
  • Advanced Guides
    • CSP Customers with Resellers
  • API Documentation
    • External Integration and API Documentation Overview
    • External Webhook Integration
    • Zapier Integration
      • External application events which trigger event in Hybr
      • Event in Hybr which trigger external Application
  • Support
    • How do I contact support?
    • How do I share feedback?
    • Roadmap
    • Changelog
  • On-Prem Installation
    • Architecture
    • Prerequisites
      • Infrastructure
        • Production
        • POC
      • Identity Providers
        • AAD B2C
        • Microsoft Entra ID
        • ADFS
      • Services
        • VConnect
        • Workflow
        • Microsoft CSP
        • Remote connect using Guacamole
          • Apache Guacamole Setup
          • Troubleshoot
          • Support Links
          • Guacamole Pre-Requisites
        • Console connect for VCenter V7
          • Pre-Requisites
          • Configurations for Nginx (Reverse Proxy Server)
          • Troubleshoot
          • Supporting Commands / Configurations
      • Ports Requirements
    • Deployment
      • Core Components
      • VConnect
      • Billing
    • Configuration
      • Billing
        • Custom Invoice
        • Multilingual Support
      • Cost Management
        • General
    • Updates
      • Billing
      • Cost Management
    • Infrastructure & Application Security - Recommendations
Powered by GitBook
On this page

Was this helpful?

  1. Features
  2. Cloud Cost Management
  3. Resource Tagging

Data Processing Rules

Data Processing Rules use a user friendly expression based on Cloud Assert's Common Cost Query Language (CCQL)

Assignment Rules are used during source data processing and transformation stages to assign values to target data properties based on incoming data property conditions.

Following rule assigns CloudSpend target property with default value as 'Service', add the property to group by list during processing. With conditions based on source data properties

ASSIGN CloudSpend WITH DEFAULT 'Service' AND GROUPBY
IF source.ServiceInfo2 LIKE '%Marketplace%' OR source.Source = 'Marketplace' THEN 'Marketplace'
END

Supported Conditional Operators

Name
Operator

Equal To

=

Not Equal To

!=

Greater Than

>

Greater Than or Equal To

>=

Less Than

<

Less Than or Equal To

<=

Like

LIKE

Contains In

IN

Not Contains In

NOT IN

Expression Operators

Name
Operator

Plus

+

Minus

-

Multiplication

*

Division

/

Modulo

%

Left Parenthesis

(

Right Parenthesis

)

Property Names

Property Names are used to refer to Source data property or target source property and they must adhere to following conventions

  1. Names must start with an alphabet

  2. Then it can be followed by alpha numeric and can contain dot and optionally enclosed within brackets like: source.[Prop Name]

Variable Names

Variable Names references parameters passed from external system and are similar to SQL Parameters

  1. Variable names must start with an alphabet and followed by alpha numeric

  2. Variable names must be prefixed with @ , like @StartDate

Examples

// Assign default NULL and Group By with multi line conditions

ASSIGN AccountOwner WITH DEFAULT NULL AND GROUPBY
  IF source.AccountOwnerId = 'Master' THEN 'FCC-Global'
  IF [Account Name] = 'FCC' THEN 'FCC-Global'
  IF [source.Account Name] = 'FCC' THEN 'FCC-Global'
  IF source.[User Name] = 'FCC' THEN 'FCC-Global'
  IF [source two].[User Name] = 'FCC' THEN 'FCC-Global'
END
// Assign default NULL and no Group By
ASSIGN AccountOwner WITH DEFAULT NULL
  IF source.AccountOwnerId = 'Master' THEN 'FCC-Global'
  IF [Account Name] = 'FCC' THEN 'FCC-Global'
  IF [source.Account Name] = 'FCC' THEN 'FCC-Global'
END
// Only Default Assignment, no conditional assignments
ASSIGN CloudSpend WITH DEFAULT 'Service' END
// Using Variables
ASSIGN CloudSpend2 WITH DEFAULT @DVar
  IF line_item_line_item_type = @Var1 OR (account_name = @AccountNameVar  AND project_code = 'GCC') THEN 'Reserved Instance'
END

PreviousResource TaggingNextCost Allocations & Budgeting

Last updated 1 year ago

Was this helpful?