<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ChristopherChen的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ChristopherChen</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ChristopherChen]]></copyright><item><title><![CDATA[VMware下设置 host-only 方式上网]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/105423288</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/105423288</guid><author>ChristopherChen</author><pubDate>Thu, 09 Apr 2020 23:29:31 +0800</pubDate><description><![CDATA[vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
BOOTPROTO=static
#BROADCAST=192.168.75.255
HWADDR=00:0C:29:0A:CA:E4
#IPADDR=192.168.75.51
#NETMASK=255.255.255.0
#NETWORK=192.168.75.0
ONBOOT=...]]></description><category></category></item><item><title><![CDATA[mvn.cmd]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/100428690</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/100428690</guid><author>ChristopherChen</author><pubDate>Mon, 02 Sep 2019 23:34:03 +0800</pubDate><description><![CDATA[@REM Licensed to the Apache Software Foundation (ASF) under one
@REM or more contributor license agreements.  See the NOTICE file
@REM distributed with this work for additional information
@REM regar...]]></description><category></category></item><item><title><![CDATA[ROLLUP]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/86671234</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/86671234</guid><author>ChristopherChen</author><pubDate>Sun, 27 Jan 2019 23:48:39 +0800</pubDate><description><![CDATA[
--206 &amp;amp; 207
在 Oracle SQL语法中， ROLLUP 用于汇总分组聚合后的数据。如果 ROLLUP 后包含多列，型如 GROUP BY ROLLUP(colA, colB) ，则会基于分组后第一个列(colA)再次进行分组汇总，最后再对所有数据进行汇总。
如果语句为 GROUP BY ROLLUP(a, b)，oracle 将会从右到左先对字段 a 和 b 先进行 GR...]]></description><category></category></item><item><title><![CDATA[单列权重计算、动态列Flag、动态页Flag]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/80902517</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/80902517</guid><author>ChristopherChen</author><pubDate>Tue, 03 Jul 2018 18:21:55 +0800</pubDate><description><![CDATA[--单列权重计算、动态列Flag、动态页Flag
CREATE TABLE City(Id INT, Name NVARCHAR(500), Weight DECIMAL(9,2));
INSERT INTO City VALUES('1','Birmingham','7.6');
INSERT INTO City VALUES('2','Montgomery','8.6');
INSERT IN...]]></description><category></category></item><item><title><![CDATA[怎样用SQL递归求各个Folder的文件数]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/80405711</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/80405711</guid><author>ChristopherChen</author><pubDate>Tue, 22 May 2018 14:52:41 +0800</pubDate><description><![CDATA[-- 数据准备
CREATE TABLE [dbo].[ContentObject] (Id NCHAR(10), Name NVARCHAR(500),ParentId NCHAR(10),Type NVARCHAR(50));
INSERT INTO [dbo].[ContentObject] VALUES('0x00000001', 'ROOT', NULL, 'Folder');
INSE...]]></description><category></category></item><item><title><![CDATA[英语札记5]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78705186</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78705186</guid><author>ChristopherChen</author><pubDate>Sun, 03 Dec 2017 22:54:57 +0800</pubDate><description><![CDATA[rock
You guys rock! 你们很棒
rock solid 坚如磐石


reserve [rɪˈzɜ:rv]
n. 保留; 保护区 v.预定
pines [painz] n. 松树, 松木
Torrey Pines State Reserve 州保留地
right near/ close to 在附近
hiking [ˈhaɪkɪŋ] n. 徒步旅行
steep]]></description><category></category></item><item><title><![CDATA[Building Data Models with PowerPivot_进阶篇2]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78705176</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78705176</guid><author>ChristopherChen</author><pubDate>Sun, 03 Dec 2017 22:54:08 +0800</pubDate><description><![CDATA[5.1 使用 Userelationship 建立两表之间的多个关系
USERELATIONSHIP(多端,一端)
Measure_送货数量 = CALCULATE(SUM([数量])),USERELATIONSHIP('销售记录'[实际送货日期],'日历年'[日期])


5.2 使用多对多关系
[多  多] 可变为 [多  多]
现在'销售记录'表 & '图书分类'表是多对多关系]]></description><category></category></item><item><title><![CDATA[英语札记 4]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78687743</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78687743</guid><author>ChristopherChen</author><pubDate>Fri, 01 Dec 2017 16:06:56 +0800</pubDate><description><![CDATA[My friend's wife lost her hard-fought battle against cancer yesterday.
昨天我朋友的妻子在与癌症卓绝的抗争中失去了生命。
lost battle 既可以当名词"败仗"，又可以当动词短语"打了败仗"
hard-fought battle 硬仗

Model Essay

take a turn for the wor]]></description><category></category></item><item><title><![CDATA[Power BI 学习要点]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78687727</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78687727</guid><author>ChristopherChen</author><pubDate>Fri, 01 Dec 2017 16:05:38 +0800</pubDate><description><![CDATA[DAX http://www.cnblogs.com/lizardbi/p/DAX-PATTERN-POWERBI-Parent-Child-Hierarchy.html
PowerQuery M语言 http://blog.youkuaiyun.com/column/details/14089.html


Power BI和Excel 2016中的多对多关系
https://www.sqlbi.]]></description><category></category></item><item><title><![CDATA[工作词汇]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78660810</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78660810</guid><author>ChristopherChen</author><pubDate>Wed, 29 Nov 2017 00:26:45 +0800</pubDate><description><![CDATA[simplify [ˈsɪmpləˌfaɪ] vt.简化
need to]]></description><category></category></item><item><title><![CDATA[Building Data Models with PowerPivot_进阶篇]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78650160</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78650160</guid><author>ChristopherChen</author><pubDate>Mon, 27 Nov 2017 22:43:43 +0800</pubDate><description><![CDATA[Building Data Models with PowerPivot_进阶篇


2.3 使用链接回标进行RFM分析
R Recent近度 MIN([近度]); [近度]=TODAY()-[下单日期]


3.1 使用高级DAX函数
高级聚合函数SUMX
SUMX函数比SUM函数高级的地方在于SUMX函数中可以嵌套使用筛选器函数
SUMX函数第一个参数是表格或者是返回表格数]]></description><category></category></item><item><title><![CDATA[SQL Server 系统信息查询]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78373475</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78373475</guid><author>ChristopherChen</author><pubDate>Sat, 28 Oct 2017 10:15:57 +0800</pubDate><description><![CDATA[--1. 怎样查看某表的创建与最后更新时间
SELECT Name
     , Create_Date
     , Modify_Date
  FROM sys.objects
 WHERE TYPE='U']]></description><category></category></item><item><title><![CDATA[Power BI 疑难问题辨析]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78324565</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78324565</guid><author>ChristopherChen</author><pubDate>Mon, 23 Oct 2017 23:07:42 +0800</pubDate><description><![CDATA[1. 多对多关系的构建
2. 单表多个时间维度与日历表的连接
3. 笛卡尔积表的构建
4. 交叉筛选关系的确立]]></description><category></category></item><item><title><![CDATA[Power BI 学习笔记02]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78252571</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78252571</guid><author>ChristopherChen</author><pubDate>Mon, 16 Oct 2017 18:10:25 +0800</pubDate><description><![CDATA[4 建立数据分析模型
4.1 建立数据模型 10节
Edit relationship
[Cross filter direction] 跨筛选器方向(交叉筛选器方向)，该项有两个选择 Single or Both。选"Both"的话，原表关系"一对多"中两个表的相应字段都可以做筛选项，如果选"Single"则只有一端(指"一对多"的一端)字段可供筛选，即用一端的字段筛选多端的度量值。
]]></description><category></category></item><item><title><![CDATA[SQL Server 生成时间序列]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78251568</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78251568</guid><author>ChristopherChen</author><pubDate>Mon, 16 Oct 2017 16:55:12 +0800</pubDate><description><![CDATA[WITH DateSequence AS (
SELECT CONVERT(DATETIME,'20150101') AS DateNum
UNION ALL
SELECT DateNum+1
  FROM DateSequence
 WHERE DateNum<DATEADD(YEAR,10,CONVERT(DATETIME,'20170101'))-1
)
SELECT ds.DateNum]]></description><category></category></item><item><title><![CDATA[Python 类方法classmethod 示例]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78247127</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78247127</guid><author>ChristopherChen</author><pubDate>Mon, 16 Oct 2017 10:31:54 +0800</pubDate><description><![CDATA[#https://github.com/pavlov99/json-rpc/blob/master/jsonrpc/manager.py

import json
import logging
from .utils import is_invalid_params
from .exceptions import (
    JSONRPCInvalidParams,
    JSONRPCInv]]></description><category></category></item><item><title><![CDATA[Power BI 学习笔记01]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78245249</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78245249</guid><author>ChristopherChen</author><pubDate>Sun, 15 Oct 2017 22:58:22 +0800</pubDate><description><![CDATA[Power BI


Powerpovit 数据视图 关系视图
将Excel工作簿导入到Power BI中，实际是将模型、KPI和度量值导入到Power BI中
[查询] 从数据源导入数据到Power BI中，查询是数据来源的连接代码


Power BI左侧 关系视图 数据视图


轴：实现钻取


将Power BI Desktop中制作的报表Publish到微软P]]></description><category></category></item><item><title><![CDATA[CGI 与 WSGI]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/78078927</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/78078927</guid><author>ChristopherChen</author><pubDate>Sun, 24 Sep 2017 19:42:23 +0800</pubDate><description><![CDATA[1.
首先，CGI是外部应用程序与 Web 服务器之间的接口标准，不同类型语言写的程序只要符合 CGI 标准，就能作为一个 CGI 程序与 Web 服务器交互，早期的 CGI 大多都是c或c++。php可以作为一个 CGI 使用，作为 CGI 时，它将作为独立的进程运行，有请求过来就创建一个进程进行响应。当php作为apache的一个模块时，php将作为apache的一个子进程存在，接受apac]]></description><category></category></item><item><title><![CDATA[Py15_1]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/77149752</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/77149752</guid><author>ChristopherChen</author><pubDate>Sun, 13 Aug 2017 20:30:45 +0800</pubDate><description><![CDATA[#!/usr/bin/env python
#_*_coding:utf-8_*_
#作业：实现用户名密码登陆验证
#1：判断用户名密码是否正确，正确则打印欢迎信息，错误则输出具体错误原因信息
#2：用户可以连续输入三次密码。超过三次则锁定用户
#3：密码位数必须超过6位
#@count 统计输入密码次数
#@name：用户名
#@password：用户密码
print '测试：用户名：ch，密码]]></description><category></category></item><item><title><![CDATA[SQL Server Binary转换]]></title><link>https://blog.youkuaiyun.com/ChristopherChen/article/details/76445510</link><guid>https://blog.youkuaiyun.com/ChristopherChen/article/details/76445510</guid><author>ChristopherChen</author><pubDate>Mon, 31 Jul 2017 15:45:37 +0800</pubDate><description><![CDATA[DECLARE @hexstring VARCHAR(MAX)='E0F0C0';
SELECT CAST('' AS XML).value('xs:hexBinary(substring(sql:variable("@hexstring"), sql:column("t.pos")) )', 'VARBINARY(MAX)')
FROM (SELECT CASE SUBSTRING(@hexst]]></description><category></category></item></channel></rss>